9 Replies Latest reply: Dec 26, 2017 10:06 AM by Bill Markham RSS

    To eliminate Null Values in Pivot Table

    SK B

      Hi All,

       

      I have a requirement to eliminate null values in Pivot table in Qliksense.

       

      I have used the below expression as measure.

       

      Only({$<Year={'$(=vlatestmnth)'},SC=,UT=,AC={'fieldfield'}>}SC &' ' &if(Unit='%','%'))

       

      The Output as below.

       

      Capture.JPG

       

      There are some null value displayed as '-'. Could please help how Can I remove these Null values and change the background colour to grey for these values.

       

      My Output Should like as below.

       

      Capture1.JPG

       

      Note : I have unchecked the Include Null values in dimension Tab and Data Handling tab.

      Thanks and Regards,

      Kishore