Discussion Board for collaboration on QlikView Layout & Visualizations.
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
Go to Solution.
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.
uncheck "suppress zero values" in the presentation tab
Dimension 'Curr' is Horizontal.
In Vertical it works.
unchecking suppress zero doesn't work
Find the qvw.
Hi..can u explain me what you did...
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.
Thank you all for your replies..i fixed the issue as you suggested
I re-write the background expression because you forget to '=' sign and also the expression in expression tab.
and its working fine for me.