Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
danielact
Partner - Creator III
Partner - Creator III
‎2013-04-18 03:40 PM

Sort affecting Column Header Color?

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?

262 Views
0 Likes
1 Reply
swuehl
MVP
MVP
‎2013-04-18 04:22 PM

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

135 Views
0 Likes