Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
dineshraj
Partner - Creator
Partner - Creator

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
poojask123
Partner - Creator
Partner - Creator

Hi Dinesh,

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

Thanks

 

d44973694
Contributor II
Contributor II

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