topic Re: Sorting with Help of a Button in QlikView

Sorting with Help of a Button

bharani8 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Sorting with Help of a Button

sunny_talwar — Thu, 14 Sep 2017 08:22:43 GMT

You can do that using a sort expression within your chart and a variable...Basically, based on a variable value, you can change the sort expression like this

If(vVar = 1, Sum(Measure), -Sum(Measure))

Re: Sorting with Help of a Button

sunny_talwar — Thu, 14 Sep 2017 08:36:22 GMT

Check the attached sample

Re: Sorting with Help of a Button

bharani8 — Thu, 14 Sep 2017 08:54:14 GMT

Wowwwww!! U r an Star!! TY so much!!

Re: Sorting with Help of a Button

bharani8 — Thu, 14 Sep 2017 08:55:06 GMT

Will try to incorporate in my DB and let u know how it goes ..

Re: Sorting with Help of a Button

effinty2112 — Thu, 14 Sep 2017 09:29:39 GMT

Hi Bharani,

I'd like to contribute something which works along with Sunny's solution.

Create a button with text : =if($(vVar) = 1,'Asc','Desc')

and give it the action to change the variable vVar to: =1-$(vVar)

Clicking this button will toggle the value of the variable between 1 and 0 and change the sort order in your chart.

Cheers

Andrew

Re: Sorting with Help of a Button

bharani8 — Thu, 14 Sep 2017 10:18:03 GMT

TY Walker for taking your time to post this!!

I was not able click on that "Mark as Helpful" as it keeps on loading.. Any ways Thanks..

Re: Sorting with Help of a Button

sunny_talwar — Thu, 14 Sep 2017 11:09:56 GMT

Hey Andrew -

Where exactly do we add this expression? Can you update my sample to show how it would work?

Thanks,

Sunny

Re: Sorting with Help of a Button

prieper — Thu, 14 Sep 2017 11:32:07 GMT

as action on click:

You only need to set vVar initially to either 0 or -1 ...

Re: Sorting with Help of a Button

sunny_talwar — Thu, 14 Sep 2017 11:33:31 GMT

Where will this go?

=if($(vVar) = 1,'Asc','Desc')

Re: Sorting with Help of a Button

prieper — Thu, 14 Sep 2017 11:39:17 GMT

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

Re: Sorting with Help of a Button

sunny_talwar — Thu, 14 Sep 2017 11:41:16 GMT

Make sense, I seem to be having hallucinations

Thanks prieper‌‌!!

Re: Sorting with Help of a Button

PoojaYadav — Mon, 05 Jul 2021 10:52:05 GMT

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