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

[rvijayanth]

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?

[rvijayanth]

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!

[rvijayanth]

Hey, were you able to access the application?

[ckarras22]

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.

[Madhab77]

This works only in simple table but not in Pivote Table

[Shubham_D]

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.