Discussion Board for collaboration related to QlikView App Development.
Hello all Experts,
I have filed with codes that include numeric and alpha .
How can I sort them in a chart like this:
And so on....
I attached a file with the codes
Go to Solution.
Try this code.
Ord(Left(Code,1)) + (Ord(Right(Code,1))/100) as Sort
(ooxml, embedded labels, table is Sheet1);
Use Sort Fields in sorting tab of property and use expression sort functionality.
View solution in original post
Please find the attached sample file..
Thanks for the quick answer.
But as you can see in the example. this is not what i need.
i need that code '1A' will be after code '19' and not after code '99'