2 Replies Latest reply: Sep 21, 2017 1:53 AM by scott wang RSS

    Qliksense pivot table problem

    scott wang

      Hi everybody,

       

      I created a pivot table in qliksense. the picture is :

      1.png

      Now Red represents the first dimension. Blue represents the second dimension.But the second value maybe has null value.

      So I want to hide rows like '-'.  But if I do not set the second dimension  to include nullvalue.then the first dimension value will be  missing.

      That's not my requoirements.

       

      My requirement is :

      When the first dimension and second dimension both have value ,then both display, but when the first dimension has value and

      second dimension has no value, then hide the second dimension rows like '-',just stay the first dimension value.


      Any idea? Thanks