Sort affecting Column Header Color?

danielact — Thu, 18 Apr 2013 19:40:50 GMT

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?

Re: Sort affecting Column Header Color?

swuehl — Thu, 18 Apr 2013 20:22:44 GMT

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

topic Re: Sort affecting Column Header Color? in QlikView

Sort affecting Column Header Color?

Re: Sort affecting Column Header Color?