Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
tinkerz1
Creator II
Creator II

Background color in pivot table dates

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)

5 Replies
swuehl
MVP
MVP

Could you post a sample QVW?

Chanty4u
MVP
MVP

Not applicable

not very clear...sample qvw pls

kamakshisuram
Creator
Creator

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
Creator
Creator

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


Custom format Cell.png