Pivot Dimension Background color

[#1]

Hello All,

Need help in creating the best way to set background color for a pivot table dimension by doing a date comparision of children records. Example being an Order Header has a due date and multiple item records with a projected due date. Need to compare the header due date with all projected due dates and if a single date meets the requirement then a color will be set. Any samples to accomplish this task will be appreciated. Thank you in advance.

JD

[IAMDV]

Hi JD,

You can use colour expressions to assign the background colours. Something like this...

If((Quantity * price)>Tprice,Green(), Red()).

You can also specify the alpha value to control the transperancy.

And I had made a video post on using the Colour expressions within QlikView. Here is the link to my blog :

http://qlikshare.com/tag/expression-in-colours

And you can read this thread, which has an example.

I hope this helps!

Cheers - DV