8 Replies Latest reply: Sep 28, 2017 9:38 AM by Dennis Hoogenboom RSS

    Chancing the default value for missing data from '-'  to zero

    Dennis Hoogenboom

      Hi,

       

      I am trying to chance the default value for missing data from '-'  to 0

       

      For example, in this pivot table the dimensions on the left has only data in some years.

      The other years give a '-' , I want to change that to the number zero

      Pivot.PNG


      Because the there is no data the IF (ISNULL   ... or IF(LEN( .... trick is not a solution.

       

      In  Qlikview it can be done on the presentation tab.

      Knipsel.PNG

       

      But I can not find this setting in Qlik Sense.

       

      Any suggestions?

       

      Thanks,

      Dennis.