Sorting Based on Measure Selected Value

[Anonymous]

Hello Qlikers,

I am having a Bar Chart with 2 dimensions  and 3 measure in qlik sense. Where measures are alternative measures.

Now what I want , which ever measure I select at UI the dimensions should get sorted w.r.t selected measures...

Please suggest.

I know adding button for same can sort out the issue but is their any other way as adding buttons will takes more space...

Regards,

BA

[Anonymous · Accepted solution]

Got the answer from one of my friend suggestion, can do like this in QS

Properties -> Sorting - > First Dim - > Sorting by expression ->

=if(getobjectmeasure()='Label of Expression1', Expression1,

if(getobjectmeasure()='Label of Expression2', Expression2))

[alexbjorlig]

Does this work? I don't get a value when using this approach

[giakoum]

I tried in Sep release and it does not work. Does it work for you??

[emiz]

This worked for me. Thank you!