Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Sort Calculated dimensions by expression

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

11 Replies
smgt90
Contributor II
Contributor II

Thanks! this helped me a lot

xavi_arm12
Contributor
Contributor

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