Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Champion
Champion

Sorting Based on Measure Selected Value

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

1 Solution

Accepted Solutions
Champion
Champion

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))

View solution in original post

4 Replies
Champion
Champion

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))

View solution in original post

Creator
Creator

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

Partner
Partner

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

Contributor II
Contributor II

This worked for me. Thank you!