22 Replies Latest reply: Apr 18, 2017 5:09 PM by Chris Karras RSS

    In Qliksense, can we show '0' instead of '-' in pivot tables when there are no such records?

    Vijayanth radha

      In Qliksense, in pivot tables, instead of '-'s, can we show '0's in place of null records?

       

      For example, we have a pivot table with dimensions Year and Category and Count as measure.

       

      Consider this data set:

       

      Counts for 2016 for Category A is 10, B is 2 and C is 7

      Counts for 2015 for Category A is   6, B is 3 and C is 0 (since category was established only in 2016)


      So our pivot table shows this:


      Year             Category A      Category B        Category C


      2016                           10                   2                       7 

      2015                            6                    3         -


      Instead, I want it to be like this: See how for 2015, category C says 0 instead of '-'


      Year             Category A      Category B        Category C


      2016                         10                    2                       7 

      2015                           6                    3                       0


      How to accomplish this?