4 Replies Latest reply: Aug 10, 2018 11:10 AM by Miguel Angel Lemos RSS

    NULLASVALUE in Qliksense master dimensions

    Manoj Kumar M R

      Hi All,

       

      I have a month column with some null values. And then I have created a master dimension based on this month column to restrict some values and then I'm using this master dimension everywhere. I have a list box with master dimension (month column) as dimension. Now I need to display Null values as 'NULL' in the list box and other charts so that users can select NULL values. I used below NULLASVALUE function on the month column, but it is not working for master dimensions. Please suggest how can I have "NULL" string in place of actual null in master dimension..

       

      NullAsValue Monthstart;

      Set NullValue = 'NULL' ;