topic Sorting changes when selection is made in QlikView

Sorting changes when selection is made

Anonymous — Wed, 23 Dec 2015 08:35:18 GMT

H All,

I have a list of months, that serves the user as a filter to slice define the report,

the field is sorted by an ascending numerical represntation of the month name, e.g. 012015, 022015, etc. (**details on sorting below)

When the user makes a choice and marks a specific month, the sorting order is changed to show the selected month on the top,

can i make it static? I believe it's confuzing the user!

** I attached 2 screenshots: a sample of the sorted simension & it's definition in Sort tab

Thanks in advance,

Nir

arulsettu — Wed, 23 Dec 2015 08:41:22 GMT

may be this

in sort tab -> expression

MinString({1} monthfield)

tresB — Wed, 23 Dec 2015 08:44:33 GMT

Write sort expression like: =Only({1} [Billing Month Num])

tyagishaila — Wed, 23 Dec 2015 08:47:21 GMT

try,

Sort--> Load Order -> Ascending

deselect rest check boxes.

Wed, 23 Dec 2015 08:54:04 GMT

i was looking for the same answer in another post , your answered helped me

thanks

Anonymous — Wed, 23 Dec 2015 08:54:34 GMT

Both options works well

Thanks pro's