topic Sorting a Calculated Dimension in QlikView https://community.qlik.com/t5/QlikView/Sorting-a-Calculated-Dimension/m-p/1341418#M839475 <HTML><HEAD></HEAD><BODY><P>Good Morning,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I am having trouble figuring out how to sort a bar chart using a calculated dimension.&nbsp;&nbsp; Qlikview sorts the data in reverse my desired order by default.&nbsp; In the example attached, I would like the top chart sorted similar to the bottom chart without having to put 1|, 2|, 3|, and so on in the calculated dimensions name.&nbsp; Any help would be greatly appreciated.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT craigsutton 2020-11-25T16:16:04Z Sorting a Calculated Dimension https://community.qlik.com/t5/QlikView/Sorting-a-Calculated-Dimension/m-p/1341418#M839475 <HTML><HEAD></HEAD><BODY><P>Good Morning,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I am having trouble figuring out how to sort a bar chart using a calculated dimension.&nbsp;&nbsp; Qlikview sorts the data in reverse my desired order by default.&nbsp; In the example attached, I would like the top chart sorted similar to the bottom chart without having to put 1|, 2|, 3|, and so on in the calculated dimensions name.&nbsp; Any help would be greatly appreciated.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Sorting-a-Calculated-Dimension/m-p/1341418#M839475 craigsutton 2020-11-25T16:16:04Z Re: Sorting a Calculated Dimension https://community.qlik.com/t5/QlikView/Sorting-a-Calculated-Dimension/m-p/1341419#M839476 <HTML><HEAD></HEAD><BODY><P>Try to put the number into the dual-part like: dual(string, number)</P><P></P><P>- Marcus</P></BODY></HTML> Fri, 28 Apr 2017 17:23:21 GMT https://community.qlik.com/t5/QlikView/Sorting-a-Calculated-Dimension/m-p/1341419#M839476 marcus_sommer 2017-04-28T17:23:21Z Re: Sorting a Calculated Dimension https://community.qlik.com/t5/QlikView/Sorting-a-Calculated-Dimension/m-p/1341420#M839477 <HTML><HEAD></HEAD><BODY><P>Thanks for the quick fix.</P></BODY></HTML> Fri, 28 Apr 2017 17:29:16 GMT https://community.qlik.com/t5/QlikView/Sorting-a-Calculated-Dimension/m-p/1341420#M839477 craigsutton 2017-04-28T17:29:16Z Re: Sorting a Calculated Dimension https://community.qlik.com/t5/QlikView/Sorting-a-Calculated-Dimension/m-p/1341421#M839478 <HTML><HEAD></HEAD><BODY><P>hi</P><P></P><P>Please find the attached file. </P><P>it is use full for you.</P></BODY></HTML> Sat, 29 Apr 2017 06:35:52 GMT https://community.qlik.com/t5/QlikView/Sorting-a-Calculated-Dimension/m-p/1341421#M839478 maniram23 2017-04-29T06:35:52Z