Sorting Via a Variable

[#1]

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

[tamilarasu · Accepted solution]

Hi Stephen,

Below link might be helpful.

Sorting a straight table based on expression via a button

[kaushiknsolanki]

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

[jyothish8807]

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

KC