Cognos Analytics

 View Only
Expand all | Collapse all

Default value for filter widget in Dashboard

  • 1.  Default value for filter widget in Dashboard

    Posted Thu February 20, 2020 08:37 AM
    Good day. Just want to know the default value if nothing has been selected from a filter widget. I'm trying this formula

    CASE
    WHEN AP_Dashboard_xlsx.Market = NULL
    THEN (AP_Dashboard_xlsx.Headcount / 7305)*100

    END

    But it's showing no value


    I also tried 'All' but same result. Appreciate any help the team here can provide.


    ------------------------------
    CAMILO CARLO MENDIOLA
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Default value for filter widget in Dashboard

    Posted Thu February 20, 2020 12:06 PM
    Hi Camilo,
    It is likely that the value is not NULL, but instead is empty or just spaces.
    When you look in the grid view, does it show NULL or an empty cell ?
    If it shows NULL then the above should have worked, in that case maybe you can send me a sample xlsx file that has the problem.
    Which version are you on?
    // Henk

    ------------------------------
    HENK CAZEMIER
    ------------------------------