If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have two tables, each one with a calculated dimension and a measures.
One of the dimensions is called "Markets" and will divide my measure by EUR, USA, INT and Others. How can I define the order like that? What expression should I use? I've tried a lot of things but not've been succeded.
Yes. I've tried expressions like this one
,if([Markets] ='International ',3
,if([Markets] ='Others',4 ))))
in the sort tab but it doesn't recognize [Markets] as a dimension .
If I put the measure above I'll be sure that the dimension fields will be always as they appear now (by chance, in this case, if I do that it will sort the dimensions as I want, but in other cases it doesn't)
,if([Markets] ='International ',Dual('International',3)
And sort it numerically..!!
In the load script
Load * Inline
then in the Chart, Sort Tab, click the Dimension you want the sort to happen - in this case Food
check the sort by expression
and key FoodSortOrder in the expression field.
it will sort in the numeric order that you defined