Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

Conditional colour formating in pivot table for Dimensions not working

Hi..i have strange problem..i just want show the "Days" column of the attached file with Red background with following conditions

1. When Days >= 30 days, Background color of Days Dimension should be red

2.Dont change the table structure ..it should remain like that only

3.in current file color is showing for some values which are > 30, for some other even if it is 120 days background color doesn't change.

I have attached the file kindly help me

thanks in advance

Tags (2)
1 Solution

Accepted Solutions
Partner
Partner

Re: Conditional colour formating in pivot table for Dimensions not working

Hi Vinod,

Check the application I've attached.

I have unchecked the "Suppress Zero-Values" and "Suppress Missing" and checked the "Populate Missing Cells" in presentation tab.

I have done a small change in expression also, else instead of "-", 0 will come.

Regards

Rajat Arora

9 Replies
Partner
Partner

Re: Conditional colour formating in pivot table for Dimensions not working

uncheck "suppress zero values" in the presentation tab

antoniotiman
Honored Contributor III

Re: Conditional colour formating in pivot table for Dimensions not working

Dimension 'Curr' is Horizontal.

In Vertical it works.

Not applicable

Re: Conditional colour formating in pivot table for Dimensions not working

unchecking suppress zero doesn't work

Partner
Partner

Re: Conditional colour formating in pivot table for Dimensions not working

Hi Vinod,

Check the application I've attached.

I have unchecked the "Suppress Zero-Values" and "Suppress Missing" and checked the "Populate Missing Cells" in presentation tab.

I have done a small change in expression also, else instead of "-", 0 will come.

Regards

Rajat Arora

Partner
Partner

Re: Conditional colour formating in pivot table for Dimensions not working

Hi,

Find the qvw.

--Jai

Not applicable

Re: Conditional colour formating in pivot table for Dimensions not working

Hi..can u explain me what you did...

Thanks

Partner
Partner

Re: Conditional colour formating in pivot table for Dimensions not working

he has done the same thing what I have done...

Unchecked the "Suppress Zero-Values" and "Suppress Missing" and checked the "Populate Missing Cells" in presentation tab.

But he has done no change in expression so instead of null sign "-", 0 is coming. Else everything is same.

Not applicable

Re: Conditional colour formating in pivot table for Dimensions not working

Thank you all for your replies..i fixed the issue as you suggested

Partner
Partner

Re: Conditional colour formating in pivot table for Dimensions not working

I re-write the background expression because you forget to '=' sign and also the expression in expression tab.

and its working fine for me.

--Jai