Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
can you post an application that demonstrates this behaviour?
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.
not able to open the app but just below should suffice
wildmatch([Adherence Status],'Always','Often','Rarely','Never','Sometimes')
Hi, Its not working...
the sorting order keeps changing due to the selection.
any way to help on that
this works fine for me even after selections made in date field and Adherence field
WildMatch([Adherence Status],'Always','Often','Sometimes','Rarely','Never')