Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
saxofonoacn
Partner - Contributor III
Partner - Contributor III

Sorting pivot table by colour

Hi all,

I have a pivot with 3 dimensions and a bunch of expressions. One of these expressions is a "flag" of days that is colour coded (below 14 days give me amber). I would need to sort this table if this flag comes up (if the colour applies). Any ideas?

thank you,

Imi

1 Reply
rubenmarin

Hi Imi, if color expression doesn't depends of dimension values, you can use the color expression as sort expression, just instead of assign a color it gets a number to order, ie:

=If(DateField-Today()<14, 1, 2)