topic Re: Sorting a Calculated dimension created using Aggr in QlikView https://community.qlik.com/t5/QlikView/Sorting-a-Calculated-dimension-created-using-Aggr/m-p/1343569#M413663 <HTML><HEAD></HEAD><BODY><P>Is this what you want?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/160560_Capture.PNG" style="height: 283px; width: 620px;" /></P></BODY></HTML> Wed, 19 Apr 2017 17:12:05 GMT sunny_talwar 2017-04-19T17:12:05Z Sorting a Calculated dimension created using Aggr https://community.qlik.com/t5/QlikView/Sorting-a-Calculated-dimension-created-using-Aggr/m-p/1343568#M413662 <HTML><HEAD></HEAD><BODY><P>All,</P><P></P><P>Just checking a small thing, when using Aggr as a calculated dimension.</P><P>I have created a Pivot table to top 3 salesman for each product.</P><P></P><P>I used aggr() for that but trying to sort the sales values in ascending but couldn't do that. I tired with new Sortable aggr() but no luck.</P><P></P><P>Any ideas would be great.</P><P>Attaching the application</P></BODY></HTML> Wed, 19 Apr 2017 16:59:23 GMT https://community.qlik.com/t5/QlikView/Sorting-a-Calculated-dimension-created-using-Aggr/m-p/1343568#M413662 kkkumar82 2017-04-19T16:59:23Z Re: Sorting a Calculated dimension created using Aggr https://community.qlik.com/t5/QlikView/Sorting-a-Calculated-dimension-created-using-Aggr/m-p/1343569#M413663 <HTML><HEAD></HEAD><BODY><P>Is this what you want?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/160560_Capture.PNG" style="height: 283px; width: 620px;" /></P></BODY></HTML> Wed, 19 Apr 2017 17:12:05 GMT https://community.qlik.com/t5/QlikView/Sorting-a-Calculated-dimension-created-using-Aggr/m-p/1343569#M413663 sunny_talwar 2017-04-19T17:12:05Z Re: Sorting a Calculated dimension created using Aggr https://community.qlik.com/t5/QlikView/Sorting-a-Calculated-dimension-created-using-Aggr/m-p/1343570#M413664 <HTML><HEAD></HEAD><BODY><P>Yes, Talwar Saab. </P><P>Really missed out checking Y Value.<IMG src="https://community.qlik.com/legacyfs/online/emoticons/silly.png" /></P></BODY></HTML> Wed, 19 Apr 2017 17:16:09 GMT https://community.qlik.com/t5/QlikView/Sorting-a-Calculated-dimension-created-using-Aggr/m-p/1343570#M413664 kkkumar82 2017-04-19T17:16:09Z