topic sorting a pivot by Expression in QlikView https://community.qlik.com/t5/QlikView/sorting-a-pivot-by-Expression/m-p/192594#M54210 <HTML><HEAD></HEAD><BODY><P>If you are using a calculated dimension, then sort by expression does not work.</P><P>Is it possible to not use a calculated dimension on your chart?</P></BODY></HTML> Sat, 19 Dec 2009 03:22:59 GMT 2009-12-19T03:22:59Z sorting a pivot by Expression https://community.qlik.com/t5/QlikView/sorting-a-pivot-by-Expression/m-p/192593#M54209 <HTML><HEAD></HEAD><BODY><P>How do I get Pivots to sort as required?</P><P>In this case the pivot needs to be sorted in Order of Discrepancy Value an (expression) over the entire set</P><P>ie in Order of Discrepancy Value give me a pivot of operator,Branch,seq,Tran,Item etc. There is also a calulated dimension on this pivot filtering only the items in a selected StockTake.</P><P>Can you use a set expression in a sort ?</P><P></P><P>ColinR</P></BODY></HTML> Fri, 18 Dec 2009 18:34:06 GMT https://community.qlik.com/t5/QlikView/sorting-a-pivot-by-Expression/m-p/192593#M54209 2009-12-18T18:34:06Z sorting a pivot by Expression https://community.qlik.com/t5/QlikView/sorting-a-pivot-by-Expression/m-p/192594#M54210 <HTML><HEAD></HEAD><BODY><P>If you are using a calculated dimension, then sort by expression does not work.</P><P>Is it possible to not use a calculated dimension on your chart?</P></BODY></HTML> Sat, 19 Dec 2009 03:22:59 GMT https://community.qlik.com/t5/QlikView/sorting-a-pivot-by-Expression/m-p/192594#M54210 2009-12-19T03:22:59Z