topic Re: Background color in pivot table dates in QlikView

Background color in pivot table dates

tinkerz1 — Mon, 21 Dec 2015 11:12:10 GMT

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)

Re: Background color in pivot table dates

swuehl — Mon, 21 Dec 2015 11:53:45 GMT

Could you post a sample QVW?

Re: Background color in pivot table dates

Chanty4u — Mon, 21 Dec 2015 11:57:49 GMT

hi,

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

hope this helps u

Re: Background color in pivot table dates

Mon, 21 Dec 2015 12:02:27 GMT

not very clear...sample qvw pls

Re: Background color in pivot table dates

kamakshisuram — Mon, 21 Dec 2015 12:29:38 GMT

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

Re: Background color in pivot table dates

thakkarrahul01 — Mon, 21 Dec 2015 12:39:26 GMT

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