5 Replies Latest reply: Jul 9, 2016 9:17 PM by Haikuo Yu RSS

    How to hide 0 value in Qlik sense when using Set Analysis?

    Haikuo Yu

      My table has two columns: myDate and myNumber.

      I use myDate as dimension and myNumber as measure, and try to plot accumulation of myNumber.

      I use the following Set Analysis to show default of myNumber on chart (bigger than 20) if I do not select a date range.

      If(GetSelectedCount(myDate),

          RangeSum ( above ( Sum(myNumber) , 0 , RowNo() ) ) ,

          RangeSum ( above ( Sum({$< myNumber *= {">=20" } >} myNumber) , 0 , RowNo() ) )

        )

      I also uncheck 'Show zero value' at Qlik sense.

      However, there is still 0 value on the chart?

      Any suggestion is appreciated!

       

      hide 0 in set analysis.JPG