topic Re: Re: Sorting in Pivot table with horizontal dimension in QlikView https://community.qlik.com/t5/QlikView/Sorting-in-Pivot-table-with-horizontal-dimension/m-p/507049#M189591 <HTML><HEAD></HEAD><BODY><P>Please find attached</P></BODY></HTML> Thu, 03 Oct 2013 10:39:43 GMT 2013-10-03T10:39:43Z Sorting in Pivot table with horizontal dimension https://community.qlik.com/t5/QlikView/Sorting-in-Pivot-table-with-horizontal-dimension/m-p/507047#M189589 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Below you find a screenshot where Dim4 values needs to be sorted such that the range 56t-140t comes after the range 50-55t</P><P>but it doesn't.</P><P><IMG alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/47183_pastedImage_3.png" style="width: 620px; height: 227px;" /></P><P></P><P>I tried to associate a number with the combination of Dim3 &amp; Dim4 to achieve this(screenshot below)</P><P><IMG alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/47184_pastedImage_4.png" style="width: auto; height: auto;" /></P><P></P><P>Dim4 in the table in screenshot 1 is sorted on the basis of sum(num) but still it doesn't get sorted in correct way for the first value of Dim3</P><P>Sorting for other values of Dim3 is ok.</P><P></P><P>Please help.</P><P></P><P></P><P>Regards</P></BODY></HTML> Thu, 03 Oct 2013 10:07:53 GMT https://community.qlik.com/t5/QlikView/Sorting-in-Pivot-table-with-horizontal-dimension/m-p/507047#M189589 2013-10-03T10:07:53Z Re: Sorting in Pivot table with horizontal dimension https://community.qlik.com/t5/QlikView/Sorting-in-Pivot-table-with-horizontal-dimension/m-p/507048#M189590 <HTML><HEAD></HEAD><BODY><P>Can you please share sample app?</P></BODY></HTML> Thu, 03 Oct 2013 10:13:02 GMT https://community.qlik.com/t5/QlikView/Sorting-in-Pivot-table-with-horizontal-dimension/m-p/507048#M189590 tresB 2013-10-03T10:13:02Z Re: Re: Sorting in Pivot table with horizontal dimension https://community.qlik.com/t5/QlikView/Sorting-in-Pivot-table-with-horizontal-dimension/m-p/507049#M189591 <HTML><HEAD></HEAD><BODY><P>Please find attached</P></BODY></HTML> Thu, 03 Oct 2013 10:39:43 GMT https://community.qlik.com/t5/QlikView/Sorting-in-Pivot-table-with-horizontal-dimension/m-p/507049#M189591 2013-10-03T10:39:43Z Re: Sorting in Pivot table with horizontal dimension https://community.qlik.com/t5/QlikView/Sorting-in-Pivot-table-with-horizontal-dimension/m-p/507050#M189592 <HTML><HEAD></HEAD><BODY><P>hi, you will notice this is a automatic sorting issue with Excel.&nbsp; Since this is a text field, it is sorting in such a way.&nbsp; You should probably rename the field either numerically or alphabetically to get the desired result</P></BODY></HTML> Thu, 03 Oct 2013 11:00:00 GMT https://community.qlik.com/t5/QlikView/Sorting-in-Pivot-table-with-horizontal-dimension/m-p/507050#M189592 2013-10-03T11:00:00Z Re: Sorting in Pivot table with horizontal dimension https://community.qlik.com/t5/QlikView/Sorting-in-Pivot-table-with-horizontal-dimension/m-p/507051#M189593 <HTML><HEAD></HEAD><BODY><P>i've associated the field with a number &amp; did sort by sum(num) but doesn't work.</P></BODY></HTML> Thu, 03 Oct 2013 11:05:50 GMT https://community.qlik.com/t5/QlikView/Sorting-in-Pivot-table-with-horizontal-dimension/m-p/507051#M189593 2013-10-03T11:05:50Z Re: Re: Sorting in Pivot table with horizontal dimension https://community.qlik.com/t5/QlikView/Sorting-in-Pivot-table-with-horizontal-dimension/m-p/507052#M189594 <HTML><HEAD></HEAD><BODY><P>Use max({1} num)</P><P></P><P>check attached</P></BODY></HTML> Thu, 03 Oct 2013 11:42:54 GMT https://community.qlik.com/t5/QlikView/Sorting-in-Pivot-table-with-horizontal-dimension/m-p/507052#M189594 Anonymous 2013-10-03T11:42:54Z Re: Sorting in Pivot table with horizontal dimension https://community.qlik.com/t5/QlikView/Sorting-in-Pivot-table-with-horizontal-dimension/m-p/507053#M189595 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>it works</P><P>but how does it work ?</P><P>please explain</P></BODY></HTML> Thu, 03 Oct 2013 11:45:40 GMT https://community.qlik.com/t5/QlikView/Sorting-in-Pivot-table-with-horizontal-dimension/m-p/507053#M189595 2013-10-03T11:45:40Z Re: Sorting in Pivot table with horizontal dimension https://community.qlik.com/t5/QlikView/Sorting-in-Pivot-table-with-horizontal-dimension/m-p/507054#M189596 <HTML><HEAD></HEAD><BODY><P>The simple reason. We are taking a Max of "num" and sorting it in asc order. so, as the series you have numbered gets sorted in the asc order and using a set we are ignoring any selection to affect the sorting.</P><P></P><P>hope this helps.</P></BODY></HTML> Thu, 03 Oct 2013 11:52:55 GMT https://community.qlik.com/t5/QlikView/Sorting-in-Pivot-table-with-horizontal-dimension/m-p/507054#M189596 Anonymous 2013-10-03T11:52:55Z Re: Sorting in Pivot table with horizontal dimension https://community.qlik.com/t5/QlikView/Sorting-in-Pivot-table-with-horizontal-dimension/m-p/507055#M189597 <HTML><HEAD></HEAD><BODY><P>why doesn't sum(num) work ?</P><P>and why does it behave the way it does ? i hope max equals sum here for each pair of Dim3 &amp; Dim4</P><P></P><P>also when we select/click any value of Dim3 the sorting becomes ok, why is it so ?</P></BODY></HTML> Thu, 03 Oct 2013 11:58:36 GMT https://community.qlik.com/t5/QlikView/Sorting-in-Pivot-table-with-horizontal-dimension/m-p/507055#M189597 2013-10-03T11:58:36Z