topic Re: Dynamic sorting in QlikView

Dynamic sorting

Thu, 28 Apr 2016 16:01:37 GMT

Hi,

I have two list boxes one with column names and the other with Asc/ Desc options. I could sort the data in straight table using the column in the first list box using sort expression like

=if('$(vSort_FieldName)'='WAL',Sum(WAL))

But how do I link with second list box Asc and Desc. When the user selects column2 and Desc, data in chart should sort accordingly.

Please help.

Thanks,

Re: Dynamic sorting

Gysbert_Wassenaar — Thu, 28 Apr 2016 16:26:05 GMT

Use two list boxes, one sorted asc and one sorted desc. Then use the Conditional display option on the Layout tab of the properties windows of the listboxes and enter an expression that returns 1 or 0 to show or hide the listbox based on the selection of the Asc-Desc listbox.

For the Asc sorted listbox: =If( AscDescField = 'Asc',1,0)

For the Desc sorted listbox: =If( AscDescField = 'Desc',1,0)

Re: Dynamic sorting

trdandamudi — Thu, 28 Apr 2016 16:27:26 GMT

See if the below link will help you...

Pivot table - dynamic sorting using variables - identifying # dimensions in chart