Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
balrajahlawat
Esteemed Contributor

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
balrajahlawat
Esteemed Contributor

Re: Sorting Based on Measure Selected Value

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

4 Replies
balrajahlawat
Esteemed Contributor

Re: Sorting Based on Measure Selected Value

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
Contributor

Re: Sorting Based on Measure Selected Value

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

Partner
Partner

Re: Sorting Based on Measure Selected Value

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

emiz
New Contributor II

Re: Sorting Based on Measure Selected Value

This worked for me. Thank you!