topic Re: List box field selections sort table data in QlikView

List box field selections sort table data

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

Hi,

We need to show like when ever an field selected in list box the table data should sort accordingly.

For that i have created an inline load which having all fields used in the table.

Required out put: when user selected Cumulative_total_orders in list box the Cumulative_total_orders in the table should sort by ascending or descending

Sorting:

LOAD * INLINE [

Sorting Column

City

Store_Id

Store_Name

Rollout_Planned_Date

Rollout_Actual_Date

Cumulative_total_orders

Cumulative_eSign_orders

percentage

];

Thanks..

Re: List box field selections sort table data

avinashelite — Wed, 03 Aug 2016 12:09:58 GMT

I don't think we have direct way to achieve this other than the macro code . You need to write a macro code for the same. One more question we have the interactive sort option in Qlikview you could use that rite?? all you need to do is just a double click

Re: List box field selections sort table data

woshua5550 — Wed, 03 Aug 2016 12:42:37 GMT

look at the attached demo , it worked but i don't think is a good way , just for your reference

maybe you don't need the list box , just double click at the head of your table

good luck

Dave