Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
tan_chungkam
Contributor

IsNull Colour in Pivot Table

Hi all,

Please find attached my excel file and my qvf files.

My question is how can i fill colour into those null value (circle in red below screenshot).image.pngMy Pivot Table

Another question is it possible to change the value '1' into 'Yes'?

Thanks for the help.

 

 

3 Replies
Channa
Contributor III

Re: IsNull Colour in Pivot Table

if(isnull(measure),red())

Channa
tan_chungkam
Contributor

Re: IsNull Colour in Pivot Table

@Channa ,

Thank you for your advice.

I'm not sure did u check my files.

It does not work.

Channa
Contributor III

Re: IsNull Colour in Pivot Table

=IF(count(Month)=1,'Yes','No')

 

it will show Yes in place of 1 but handling Null is not working

 

 

Channa