Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

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
99
Views
1
Comments
User_28Q0J
User_28Q0J Rank 3 - Community Apprentice
edited Aug 13, 2024 5:19PM in Oracle Analytics Cloud and Server

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 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