Sorting with Help of a Button

[bharani8]

Hi Experts - I have a chart... Am trying to figure out whether we have an option like.. On click of an button, My dimension (which is sorted based on my expression) should change from Asc to Desc and vice versa...

Regards

Bharani

[prieper]

You may use it for the description of the button:

IF ($(vVar), 'Asc', 'Desc')

similar then in the sort-property of the listbox

IF ($(vVar), 'SUM(Sales)', '-SUM(Sales)')

[sunny_talwar]

Make sense, I seem to be having hallucinations

Thanks prieper‌‌!!

[PoojaYadav]

Hi Sunny,

I am trying to achieve this in bar chart, qliksense where I am not able to sort using expression:

Sorting Options Available

So I have passed this condition(If(vVar=1,Sum(Measure),-Sum(Measure))) as measure, but When I am sorting in ascending mode it is showing negative values. See below:

Please Suggest