https://community.qlik.com/t5/QlikView/sorting-problem/m-p/1814861#M1212909 <P>In a pivot table I have three dimensions and one calculated value.</P><P>First dimension is sorted by a string value within my table.The second and third dimension should be sorted by the value of the expression.</P><P>I tried to use the expression as a sorting expression of the third and second dimension. I don't get the correct sorting.</P><P>Alternatives like aggr and ranking did not give the correct results either.</P><P>In the soring tab it is not possible to demote or promote the dimensions&nbsp;</P><P>Using the Y-value&nbsp; affects the sorting of the first dimension too.</P><P>How to solve this ?</P> Mon, 14 Jun 2021 11:41:54 GMT curiousfellow 2021-06-14T11:41:54Z https://community.qlik.com/t5/QlikView/sorting-problem/m-p/1814861#M1212909 <P>In a pivot table I have three dimensions and one calculated value.</P><P>First dimension is sorted by a string value within my table.The second and third dimension should be sorted by the value of the expression.</P><P>I tried to use the expression as a sorting expression of the third and second dimension. I don't get the correct sorting.</P><P>Alternatives like aggr and ranking did not give the correct results either.</P><P>In the soring tab it is not possible to demote or promote the dimensions&nbsp;</P><P>Using the Y-value&nbsp; affects the sorting of the first dimension too.</P><P>How to solve this ?</P> Mon, 14 Jun 2021 11:41:54 GMT https://community.qlik.com/t5/QlikView/sorting-problem/m-p/1814861#M1212909 curiousfellow 2021-06-14T11:41:54Z