topic Pivot Dimension Background color in QlikView

Pivot Dimension Background color

Thu, 17 May 2012 19:49:45 GMT

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.

Re: Pivot Dimension Background color

IAMDV — Thu, 17 May 2012 20:30:25 GMT

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