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

Conditional colour formating in pivot table for Dimensions not working

Sun, 11 May 2014 18:21:25 GMT

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

giakoum — Sun, 11 May 2014 18:56:46 GMT

uncheck "suppress zero values" in the presentation tab

antoniotiman — Sun, 11 May 2014 19:20:32 GMT

Dimension 'Curr' is Horizontal.

In Vertical it works.

Mon, 12 May 2014 04:45:51 GMT

unchecking suppress zero doesn't work

rajat2392 — Mon, 12 May 2014 05:45:07 GMT

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

jsingh71 — Mon, 12 May 2014 06:10:07 GMT

Hi,

Find the qvw.

--Jai

Mon, 12 May 2014 06:38:42 GMT

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

Thanks

rajat2392 — Mon, 12 May 2014 06:53:23 GMT

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.

Mon, 12 May 2014 09:56:40 GMT

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

jsingh71 — Mon, 12 May 2014 10:21:37 GMT

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