topic Re: sorting in line chart in QlikView https://community.qlik.com/t5/QlikView/sorting-in-line-chart/m-p/969251#M332040 <HTML><HEAD></HEAD><BODY><P>Hi Paul,</P><P></P><P>I do think you can sort by D2 only. I think you can just try unchecking all the checkboxing and leaving the expression one checked. All the other dimensions should have all their checkboxes unchecked. Please see below</P><P></P><P><IMG alt="sort.png" class="jive-image image-1" height="261" src="https://community.qlik.com/legacyfs/online/96654_sort.png" style="height: 260.976px; width: 483px;" width="483" /></P></BODY></HTML> Fri, 21 Aug 2015 09:54:01 GMT Anonymous 2015-08-21T09:54:01Z sorting in line chart https://community.qlik.com/t5/QlikView/sorting-in-line-chart/m-p/969248#M332037 <HTML><HEAD></HEAD><BODY><P>I am using a line chart in which I have dimensions D1, D2 and an expression E.</P><P>I want to sort D2 using a logic other than 'E'. I tried to write that logic in the the sort tab but still the dimension is getting sorted on value of 'E'.</P><P>Any other way of sorting the expression?</P></BODY></HTML> Fri, 21 Aug 2015 09:25:23 GMT https://community.qlik.com/t5/QlikView/sorting-in-line-chart/m-p/969248#M332037 2015-08-21T09:25:23Z Re: sorting in line chart https://community.qlik.com/t5/QlikView/sorting-in-line-chart/m-p/969249#M332038 <HTML><HEAD></HEAD><BODY><P>I think sorting done first based on expression then based on your sorting criteria</P><P>Try to give the sorting condition is D2 in sorting tab</P></BODY></HTML> Fri, 21 Aug 2015 09:39:59 GMT https://community.qlik.com/t5/QlikView/sorting-in-line-chart/m-p/969249#M332038 2015-08-21T09:39:59Z Re: sorting in line chart https://community.qlik.com/t5/QlikView/sorting-in-line-chart/m-p/969250#M332039 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-users/204186">arumamahesh</A>‌ I gave sorting condition in sorting tab only. Still D2 is getting sorted on expression only.</P></BODY></HTML> Fri, 21 Aug 2015 09:45:32 GMT https://community.qlik.com/t5/QlikView/sorting-in-line-chart/m-p/969250#M332039 2015-08-21T09:45:32Z Re: sorting in line chart https://community.qlik.com/t5/QlikView/sorting-in-line-chart/m-p/969251#M332040 <HTML><HEAD></HEAD><BODY><P>Hi Paul,</P><P></P><P>I do think you can sort by D2 only. I think you can just try unchecking all the checkboxing and leaving the expression one checked. All the other dimensions should have all their checkboxes unchecked. Please see below</P><P></P><P><IMG alt="sort.png" class="jive-image image-1" height="261" src="https://community.qlik.com/legacyfs/online/96654_sort.png" style="height: 260.976px; width: 483px;" width="483" /></P></BODY></HTML> Fri, 21 Aug 2015 09:54:01 GMT https://community.qlik.com/t5/QlikView/sorting-in-line-chart/m-p/969251#M332040 Anonymous 2015-08-21T09:54:01Z Re: sorting in line chart https://community.qlik.com/t5/QlikView/sorting-in-line-chart/m-p/969252#M332041 <HTML><HEAD></HEAD><BODY><P>Use Promte/Demote option under Sort tab and make the dimension in first position (based on you want to sort)&nbsp; and uncheck all the sorting checkbox for expression.</P></BODY></HTML> Fri, 21 Aug 2015 10:00:13 GMT https://community.qlik.com/t5/QlikView/sorting-in-line-chart/m-p/969252#M332041 jsingh71 2015-08-21T10:00:13Z Re: sorting in line chart https://community.qlik.com/t5/QlikView/sorting-in-line-chart/m-p/969253#M332042 <HTML><HEAD></HEAD><BODY><P>I have done that only. Please check the attached screenshot.<IMG alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/96655_Untitled.png" style="height: 408px; width: 620px;" /></P></BODY></HTML> Fri, 21 Aug 2015 10:10:05 GMT https://community.qlik.com/t5/QlikView/sorting-in-line-chart/m-p/969253#M332042 2015-08-21T10:10:05Z Re: sorting in line chart https://community.qlik.com/t5/QlikView/sorting-in-line-chart/m-p/969254#M332043 <HTML><HEAD></HEAD><BODY><P>There is no option of Promote/ Demote in Sort Tab. I think that comes in straight table only.</P></BODY></HTML> Fri, 21 Aug 2015 10:11:36 GMT https://community.qlik.com/t5/QlikView/sorting-in-line-chart/m-p/969254#M332043 2015-08-21T10:11:36Z Re: sorting in line chart https://community.qlik.com/t5/QlikView/sorting-in-line-chart/m-p/969255#M332044 <HTML><HEAD></HEAD><BODY><P>does it work if you change the sort order to say state /descending/ascending?</P><P></P><P>may be you have an error in your expression perhaps?</P><P></P><P>hth</P><P>Sas</P></BODY></HTML> Fri, 21 Aug 2015 10:13:29 GMT https://community.qlik.com/t5/QlikView/sorting-in-line-chart/m-p/969255#M332044 sasiparupudi1 2015-08-21T10:13:29Z Re: sorting in line chart https://community.qlik.com/t5/QlikView/sorting-in-line-chart/m-p/969256#M332045 <HTML><HEAD></HEAD><BODY><P>To promote the dimension, you will have to promote in the dimensions tab.</P></BODY></HTML> Fri, 21 Aug 2015 10:14:59 GMT https://community.qlik.com/t5/QlikView/sorting-in-line-chart/m-p/969256#M332045 Anonymous 2015-08-21T10:14:59Z Re: sorting in line chart https://community.qlik.com/t5/QlikView/sorting-in-line-chart/m-p/969257#M332046 <HTML><HEAD></HEAD><BODY><P>I converted the same chart to line chart and it was showing correct result. So I don't think there is any error in expression.</P></BODY></HTML> Fri, 21 Aug 2015 11:32:22 GMT https://community.qlik.com/t5/QlikView/sorting-in-line-chart/m-p/969257#M332046 2015-08-21T11:32:22Z Re: sorting in line chart https://community.qlik.com/t5/QlikView/sorting-in-line-chart/m-p/969258#M332047 <HTML><HEAD></HEAD><BODY><P>Here D1 is my primary dimension so I cannot promote D2 in dimension tab.</P></BODY></HTML> Fri, 21 Aug 2015 11:33:05 GMT https://community.qlik.com/t5/QlikView/sorting-in-line-chart/m-p/969258#M332047 2015-08-21T11:33:05Z