Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.


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,


1 Reply

Re: Sorting pivot table by colour

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)