Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table with 1 dimension and 3 expressions. The dimension is Employee Name The 3 expressions are Salary, Bonus, and Stock Shares.
I have the Background Color set with the following: if(StockShares>0,LightGreen()) for all 3 expressions and the dimension, as I want to highlight any employee who is receiving shares.
I'm using an expression to sort the dimension If I sort it alphabetically, everything is fine. But when I sort it by Bonus (which is how I want it), the column headers turn light green. Any idea why this is happening, and how I can make it stop?
There is a known issue with color attribute expressions on pivot tables affecting the headers, which may has been fixed in latest SR.
Please check these threads and the threads referenced therein:
http://community.qlik.com/message/336990#336990
http://community.qlik.com/message/307378#307378
Regards,
Stefan