Sorting a Calculated Dimension

[craigsutton]

Good Morning,

      I am having trouble figuring out how to sort a bar chart using a calculated dimension.   Qlikview sorts the data in reverse my desired order by default.  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.  Any help would be greatly appreciated.

[marcus_sommer · Accepted solution]

Try to put the number into the dual-part like: dual(string, number)

- Marcus

[craigsutton]

Thanks for the quick fix.

[maniram23]

hi

Please find the attached file.

it is use full for you.