topic Sorting pivot table by colour in QlikView https://community.qlik.com/t5/QlikView/Sorting-pivot-table-by-colour/m-p/825031#M536797 <HTML><HEAD></HEAD><BODY><P>Hi all, </P><P>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?</P><P></P><P>thank you,</P><P>Imi </P></BODY></HTML> Wed, 26 Nov 2014 15:04:53 GMT saxofonoacn 2014-11-26T15:04:53Z Sorting pivot table by colour https://community.qlik.com/t5/QlikView/Sorting-pivot-table-by-colour/m-p/825031#M536797 <HTML><HEAD></HEAD><BODY><P>Hi all, </P><P>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?</P><P></P><P>thank you,</P><P>Imi </P></BODY></HTML> Wed, 26 Nov 2014 15:04:53 GMT https://community.qlik.com/t5/QlikView/Sorting-pivot-table-by-colour/m-p/825031#M536797 saxofonoacn 2014-11-26T15:04:53Z Re: Sorting pivot table by colour https://community.qlik.com/t5/QlikView/Sorting-pivot-table-by-colour/m-p/825032#M536798 <HTML><HEAD></HEAD><BODY><P>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:</P><P>=If(DateField-Today()&lt;14, 1, 2)</P></BODY></HTML> Wed, 26 Nov 2014 15:16:51 GMT https://community.qlik.com/t5/QlikView/Sorting-pivot-table-by-colour/m-p/825032#M536798 rubenmarin 2014-11-26T15:16:51Z