Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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