Background color in pivot table dates

[tinkerz1]

Hi,

I have posted 2 pictures that show if the first line of the pivot table data is blank then the background color on the dates wont work.

Here is the code for the background, what am I missing to get around this problem?

I just want to color the dates grey when less than a date, the code below is just to show how I am coloring at the moment.

=

RGB(224,224,224)

[swuehl]

Could you post a sample QVW?

[Chanty4u]

hi,

https://community.qlik.com/message/191996#191996

hope this helps u

[#4]

not very clear...sample qvw pls

[kamakshisuram]

It did not do any wrong. It is bug in Qlikview. If there is data , the condition will validate and color will change. If no data, condition will not apply

[thakkarrahul01]

You can use custom format cells options to give background colour to columns in pivot table. Let me know if you need more details.