Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Please take a look at this app. You will see that some cells have a '-' in them with a grey color. I need to show them as zero with white background like other values.
Please help!
Hey, were you able to access the application?
Hello vijayanth,
You can't have the '-' replaced by 0 because the null thing is happening after your "if" check statement. To understand why this is true, think like this
Year Categories Values
2016 Category A 10
2016 Category B 2
2016 Category C 7
2015 Category A 6
2015 Category B 3
In the table above there is no 2015 Category C, so nothing to check when you pivot
BR
Chris K.
This works only in simple table but not in Pivote Table
Hi @Gysbert_Wassenaar ,
There must be some other way I guess, rather than adding data from script, anyway.
Can you please put some light on adding data from script...
Shubham.