Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Background color for null values in pivot table

Hi all,

I need to give specific color for null values in pivot table. I tried all methods given in previous queries none on them is working.

I have two dimensions in rows one dimension in column and one measure.

can anyone suggest new idea?

Thanks in advance

2 Replies
Highlighted
Contributor III
Contributor III

Hi Dinesh,

Did you find a solution for this ? I am stuck with a similar requirement. Please help.

Thanks

 

Highlighted
Contributor II
Contributor II

Did you try replacing null values of the measure with 0 ? you can do it by alt(measure,0).