Sorting Order in a 2nd dimesnion is not working properly

[Vasunthra_R]

Hi, 

I have used the below expression to sort the 2nd dimension values.

pick(match([Adherence Status],'Always','Often','Rarely','Never','Sometimes'),1,2,3,4,5)

However in Qlik sense, 'Sometimes' in my data is not coming in the sort order which i gave above

Data and the expression is same still it behaves different with the selection. Can someone help me with this pls.

[MarcoWedel]

can you post an application that demonstrates this behaviour?

[Vasunthra_R]

I have attached the QVF.

In that app select the date range 'Last Year'. Then you will see the sometimes in the last order even though i have used expression to display at 3rd.

[vinieme12]

not able to open the app but just below should suffice

wildmatch([Adherence Status],'Always','Often','Rarely','Never','Sometimes')

[Vasunthra_R]

Hi, Its not working...

the sorting order keeps changing due to the selection.

any way to help on that

[vinieme12]

this works fine for me even after selections made in date field and Adherence field

WildMatch([Adherence Status],'Always','Often','Sometimes','Rarely','Never')