Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
We value your feedback – take our 5-minute QlikView modernization survey
cancel
Showing results for 
Search instead for 
Did you mean: 
bharani8
Creator III
Creator III

Sorting with Help of a Button

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

12 Replies
prieper
Master II
Master II

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
Contributor II
Contributor II

Hi Sunny,

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

Sorting Options AvailableSorting 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:

 

Sorting2.PNG

Please Suggest