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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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)