Oracle Transactional Business Intelligence Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Transactional Business Intelligence Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Filter on blank and future dates

Received Response
262
Views
2
Comments
slgott
slgott Rank 4 - Community Specialist
in Oracle Transactional Business Intelligence Forum

Summary

Create a filter using SQL expression to show just the null and future dated values

Content

Hello, 

I have a need to see only the null values and future dates. I'm strugglin to get the syntax for my SQL expression in the filter. I'm using "Is greater than OR null. See screenshots. Any suggestions? If SQL expression is not the right way to go, I'm open to other options. 

Thanks,

Stephanie

Tagged:

Answers

  • Aaron Leggett
    Aaron Leggett Rank 5 - Community Champion

    Hey Stephanie, 

    Try this: 

    (CASE WHEN IFNULL("Folder"."Due Date", CURRENT_DATE +1) > CURRENT_DATE THEN 'Y' ELSE 'N' END) = 'Y' 

    Just change the "Folder"."Due Date" to your Due Date column. 

    Essentially we're replacing the NULL values with the current date + 1, so they will always be greater than the current date. Should hopefully work! 

    Thanks

    Aaron

  • SantoshKumarBhairi
    SantoshKumarBhairi Rank 6 - Analytics & AI Lead

    Hi Stephanie, Can you please try?

    1) create two conditions -> (a) Due Date is greater than current_date (b) Due Date is null

    2) click on AND and change this to OR