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.




      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.




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

      Thanks and Regards,