topic Re: Sorting Via a Variable in QlikView

Sorting Via a Variable

Thu, 28 Jul 2016 06:44:41 GMT

Hi All,

I have a variable vTB, its either on or off (0/1)

When the button is clicked, the variable is updated to the alternative, i want the order of my table then be sorted in the following way:

pseudocode:

if vTB=1 then sort based on [Total Volume] ascending else sort on [Total Volume] descending

Anyone???

Thanks

Re: Sorting Via a Variable

tamilarasu — Thu, 28 Jul 2016 07:11:52 GMT

Hi Stephen,

Below link might be helpful.

Sorting a straight table based on expression via a button

Re: Sorting Via a Variable

kaushiknsolanki — Thu, 28 Jul 2016 07:13:23 GMT

Hi,

As far as I know there is no function to do the sorting based on condition.

The only workaround I can think of is, you keep 2 charts sorted as per your requirement.

When your Variable is ON you show one chart and second will be hidden and same way when your variable is OFF you show the hidden chart and Hide the shown chart.

You can get that idea from below link.

QlikView App: Show and Hide Windows Dynamically

Regards,

Kaushik Solanki

Re: Sorting Via a Variable

jyothish8807 — Thu, 28 Jul 2016 07:47:56 GMT

Hi Stephen,

What you can do is create two dimension or expression and set one in ascending order and other in descending order.

Now put conditional show on both dimension or expression and show only one at a time.

Hope this trick will fulfill your requirement.

Regards