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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
1 Reply
rubenmarin
MVP
MVP

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)