topic Re: Sort the Dimensions dynamically in QlikView

Sort the Dimensions dynamically

Anonymous — Tue, 08 Mar 2016 04:47:06 GMT

hi,

I have a dimension named empname and values in expression.

empname values

ram 100

par 300

peter 50

steven 120

bass 30

I need to display the empnames as follows.

empname values

steven 120

bass 30

peter 50

ram 100

par 300

obviously i cant sort the names as above using sort tab in any of the objects, How do i display the above , (i.e) i have to sort those names dynamically. Need your help

Thanks

Re: Sort the Dimensions dynamically

marcus_sommer — Tue, 08 Mar 2016 07:46:39 GMT

If you didn#T want an aplhanumeric sorting you need to define your sort-order within the script - to adjust the load-order or with an additionally sort-table - or you could use a sorting expression within the object like:

pick(match(empname, 'steven', 'bass', ...), 1, 2, ...)

- Marcus

Re: Sort the Dimensions dynamically

Anonymous — Tue, 08 Mar 2016 07:56:26 GMT

Thank you. I used in a sorting expression in an object. It worked.