Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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

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

giakoum
Partner - Master II
Partner - Master II

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

emiz
Contributor II
Contributor II

This worked for me. Thank you!