Sort Calculated dimensions by expression

[Anonymous]

Hi all,

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.

Thank you.

Sofia Vaz

[smgt90]

Thanks! this helped me a lot

[xavi_arm12]

Hi @sunny_talwar 

Definitely that was a great tip. Thanks for sharing. It was really helpful.

But I still can't understand why is only({1}....) working in terms of sorting a calculated dimension...

Is there any explation that also will help to understand how Qlik "thinks"?

Thank you in advanced