https://community.qlik.com/t5/QlikView/Sorting-issues/m-p/1801062#M1211686 <P>Hello guys,</P><P>I've the following chart, which is working with the following expressions and dimensions:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="brunolelli87_0-1618946537515.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/53317iE0E4D4A9632B059E/image-size/medium?v=v2&amp;px=400" role="button" title="brunolelli87_0-1618946537515.png" alt="brunolelli87_0-1618946537515.png" /></span></P><P><STRONG>Expression:<BR /></STRONG>count(DISTINCT KEYC)</P><P><STRONG>Dimensions:</STRONG><BR />DASC //Date format<BR />NCIC //Company name</P><P>And I'm sorting DASC by Numberic Value, and NCIC by the same expression:&nbsp;count(DISTINCT KEYC)</P><P><STRONG>My question is:</STRONG><BR />Why it is not sorting NCIA by the result of expression?<BR /><BR />I would like to have Dates (DATC) on cronological order on X axis and the result of expression (count(DISTINCT KEYC)) ordered from the biggest to the smallest result per NCIA on Y.</P><P>How can I do that?<BR />Thanks</P> Fri, 23 Apr 2021 16:05:18 GMT brunolelli87 2021-04-23T16:05:18Z https://community.qlik.com/t5/QlikView/Sorting-issues/m-p/1801062#M1211686 <P>Hello guys,</P><P>I've the following chart, which is working with the following expressions and dimensions:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="brunolelli87_0-1618946537515.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/53317iE0E4D4A9632B059E/image-size/medium?v=v2&amp;px=400" role="button" title="brunolelli87_0-1618946537515.png" alt="brunolelli87_0-1618946537515.png" /></span></P><P><STRONG>Expression:<BR /></STRONG>count(DISTINCT KEYC)</P><P><STRONG>Dimensions:</STRONG><BR />DASC //Date format<BR />NCIC //Company name</P><P>And I'm sorting DASC by Numberic Value, and NCIC by the same expression:&nbsp;count(DISTINCT KEYC)</P><P><STRONG>My question is:</STRONG><BR />Why it is not sorting NCIA by the result of expression?<BR /><BR />I would like to have Dates (DATC) on cronological order on X axis and the result of expression (count(DISTINCT KEYC)) ordered from the biggest to the smallest result per NCIA on Y.</P><P>How can I do that?<BR />Thanks</P> Fri, 23 Apr 2021 16:05:18 GMT https://community.qlik.com/t5/QlikView/Sorting-issues/m-p/1801062#M1211686 brunolelli87 2021-04-23T16:05:18Z