topic Re: Sorting Order in a 2nd dimesnion is not working properly in App Development

Sorting Order in a 2nd dimesnion is not working properly

Vasunthra_R — Mon, 23 Jan 2023 10:17:00 GMT

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.

Re: Sorting Order in a 2nd dimesnion is not working properly

MarcoWedel — Mon, 23 Jan 2023 19:50:00 GMT

can you post an application that demonstrates this behaviour?

Re: Sorting Order in a 2nd dimesnion is not working properly

Vasunthra_R — Tue, 24 Jan 2023 07:09:41 GMT

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.

Re: Sorting Order in a 2nd dimesnion is not working properly

vinieme12 — Wed, 25 Jan 2023 06:44:52 GMT

not able to open the app but just below should suffice

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

Re: Sorting Order in a 2nd dimesnion is not working properly

Vasunthra_R — Wed, 25 Jan 2023 07:34:52 GMT

Hi, Its not working...

the sorting order keeps changing due to the selection.

any way to help on that

Re: Sorting Order in a 2nd dimesnion is not working properly

vinieme12 — Wed, 25 Jan 2023 08:24:00 GMT

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

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