Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

Filter using presentation variable All values

Received Response
91
Views
1
Comments
User_28Q0J
User_28Q0J Rank 3 - Community Apprentice
edited Aug 13, 2024 5:19PM in Oracle Analytics Forum

Hi All

I have a date prompt which am  using it on a measure column with "Filter Using" function. The syntax am using is

The date prompt has "All Column Values" by default with multi select option.

With this syntax Filter( sales using order date=@{date_variable}) when I select multiple values, the columns works as expected but it fails when All Column Values is selected.

How do I make it work for All Column Values.

Thanks

Answers

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics & AI Lead

    I just answered this exact question from "3715500".  Here's my answer:

    "All Column values" passes a null value to the filter. In your filtered column, you can try a case statement along the lines of:

    CASE WHEN '@{order date}'='' THEN sum("sales Price") ELSE Filter( "Sales price" using "order date" in  (@{order date}) ) END

    Jerry