topic Re: Sort Order in QlikView https://community.qlik.com/t5/QlikView/Sort-Order/m-p/1400513#M424632 <HTML><HEAD></HEAD><BODY><P>I have tried that but still not working. I have attached my sample data pls advise</P></BODY></HTML> Wed, 13 Sep 2017 05:10:30 GMT upaliwije 2017-09-13T05:10:30Z Sort Order https://community.qlik.com/t5/QlikView/Sort-Order/m-p/1400504#M424623 <HTML><HEAD></HEAD><BODY><P>Hi Friends</P><P></P><P>I have following Pivot table in my doc</P><P><IMG alt="Screenshot_1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/176280_Screenshot_1.png" style="height: auto;" /></P><P>I want to Total Column come to the bottom of table and Dept 1 &amp; Dept 2 to remain as it is. The sorting order is </P><P>sum(PREMIUM) descending </P><P></P><P>Further I have a calculated dimension as shown below</P><P></P><P>=pick(Dim,DEPT,'TOTAL')</P><P></P><P>Pls help me</P></BODY></HTML> Tue, 12 Sep 2017 16:45:58 GMT https://community.qlik.com/t5/QlikView/Sort-Order/m-p/1400504#M424623 upaliwije 2017-09-12T16:45:58Z Re: Sort Order https://community.qlik.com/t5/QlikView/Sort-Order/m-p/1400505#M424624 <HTML><HEAD></HEAD><BODY><P>Sort this dimension using this expression:</P><P><STRONG>Only({1} Dim)</STRONG></P></BODY></HTML> Tue, 12 Sep 2017 16:50:28 GMT https://community.qlik.com/t5/QlikView/Sort-Order/m-p/1400505#M424624 sunny_talwar 2017-09-12T16:50:28Z Re: Sort Order https://community.qlik.com/t5/QlikView/Sort-Order/m-p/1400506#M424625 <HTML><HEAD></HEAD><BODY><P>still no change&nbsp; Same result</P></BODY></HTML> Tue, 12 Sep 2017 16:56:57 GMT https://community.qlik.com/t5/QlikView/Sort-Order/m-p/1400506#M424625 upaliwije 2017-09-12T16:56:57Z Re: Sort Order https://community.qlik.com/t5/QlikView/Sort-Order/m-p/1400507#M424626 <HTML><HEAD></HEAD><BODY><P>Did you sort this calculated dimension (<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=pick(Dim,DEPT,'TOTAL'))</SPAN> using this -&gt; (<STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Only({1} Dim)) </STRONG>on the sort tab?</P></BODY></HTML> Tue, 12 Sep 2017 17:00:50 GMT https://community.qlik.com/t5/QlikView/Sort-Order/m-p/1400507#M424626 sunny_talwar 2017-09-12T17:00:50Z Re: Sort Order https://community.qlik.com/t5/QlikView/Sort-Order/m-p/1400508#M424627 <HTML><HEAD></HEAD><BODY><P>Yes Sunny</P><P></P><P><IMG alt="Screenshot_1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/176283_Screenshot_1.png" style="height: auto;" /></P></BODY></HTML> Tue, 12 Sep 2017 17:03:05 GMT https://community.qlik.com/t5/QlikView/Sort-Order/m-p/1400508#M424627 upaliwije 2017-09-12T17:03:05Z Re: Sort Order https://community.qlik.com/t5/QlikView/Sort-Order/m-p/1400509#M424628 <HTML><HEAD></HEAD><BODY><P>Change Descending to Ascending.</P><P></P><P>Also mark the Text checkbox and see if it works.</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Tue, 12 Sep 2017 17:08:16 GMT https://community.qlik.com/t5/QlikView/Sort-Order/m-p/1400509#M424628 kaushiknsolanki 2017-09-12T17:08:16Z Re: Sort Order https://community.qlik.com/t5/QlikView/Sort-Order/m-p/1400510#M424629 <HTML><HEAD></HEAD><BODY><P>Then Total comes in between Dept </P></BODY></HTML> Tue, 12 Sep 2017 17:11:09 GMT https://community.qlik.com/t5/QlikView/Sort-Order/m-p/1400510#M424629 upaliwije 2017-09-12T17:11:09Z Re: Sort Order https://community.qlik.com/t5/QlikView/Sort-Order/m-p/1400511#M424630 <HTML><HEAD></HEAD><BODY><P>Uncheck the sorting order for Description and check.</P><P></P><P>If that also doesnt work then please share the sample data to understand it in detail.</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Tue, 12 Sep 2017 17:12:47 GMT https://community.qlik.com/t5/QlikView/Sort-Order/m-p/1400511#M424630 kaushiknsolanki 2017-09-12T17:12:47Z Re: Sort Order https://community.qlik.com/t5/QlikView/Sort-Order/m-p/1400512#M424631 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><STRONG>RangeSum(Only({1} Dim), Rank(DEPT))</STRONG></P><P>and sort ascending</P><P></P><P>If that doesn't work, try this</P><P><STRONG style="font-size: 13.3333px;">RangeSum(Only({1} Dim), -Rank(DEPT))</STRONG></P><P><SPAN style="font-size: 13.3333px;">and sort ascending</SPAN></P></BODY></HTML> Tue, 12 Sep 2017 17:16:36 GMT https://community.qlik.com/t5/QlikView/Sort-Order/m-p/1400512#M424631 sunny_talwar 2017-09-12T17:16:36Z Re: Sort Order https://community.qlik.com/t5/QlikView/Sort-Order/m-p/1400513#M424632 <HTML><HEAD></HEAD><BODY><P>I have tried that but still not working. I have attached my sample data pls advise</P></BODY></HTML> Wed, 13 Sep 2017 05:10:30 GMT https://community.qlik.com/t5/QlikView/Sort-Order/m-p/1400513#M424632 upaliwije 2017-09-13T05:10:30Z Re: Sort Order https://community.qlik.com/t5/QlikView/Sort-Order/m-p/1400514#M424633 <HTML><HEAD></HEAD><BODY><P>Is this not what you want?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/176345_Capture.PNG" style="height: 287px; width: 620px;" /></P><P></P><P>or is this not what you are seeing at your end?</P></BODY></HTML> Wed, 13 Sep 2017 08:23:07 GMT https://community.qlik.com/t5/QlikView/Sort-Order/m-p/1400514#M424633 sunny_talwar 2017-09-13T08:23:07Z Re: Sort Order https://community.qlik.com/t5/QlikView/Sort-Order/m-p/1400515#M424634 <HTML><HEAD></HEAD><BODY><P>This is what I want . Highest Value in 2017 to come to the top<IMG alt="Screenshot_1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/176359_Screenshot_1.png" style="height: 159px; width: 620px;" /></P></BODY></HTML> Wed, 13 Sep 2017 09:07:53 GMT https://community.qlik.com/t5/QlikView/Sort-Order/m-p/1400515#M424634 upaliwije 2017-09-13T09:07:53Z Re: Sort Order https://community.qlik.com/t5/QlikView/Sort-Order/m-p/1400516#M424635 <HTML><HEAD></HEAD><BODY><P>Check with this</P><P></P><P><STRONG>RangeSum(Only({1} DimF),&nbsp; -sum({&lt;RISK_YEAR = {$(=Max(RISK_YEAR))},RISK_DATE={$(vP17)}&gt;}PREMIUM)/1e10)</STRONG></P></BODY></HTML> Wed, 13 Sep 2017 11:37:11 GMT https://community.qlik.com/t5/QlikView/Sort-Order/m-p/1400516#M424635 sunny_talwar 2017-09-13T11:37:11Z