topic Re: Capturing the sorted column in a table in QlikView

Capturing the sorted column in a table

Tue, 05 Aug 2014 10:16:10 GMT

I have a table having multiple columns with 'interactive sort' as 'on'. Now I also have placeholders wherein I show data of Top1/Top2/Top3/Top5 Customers based on selection (please see the attached QVW). But these place holders show data correctly only if the table is sorted on Market column.

Is there a way to physically capture which column is the table being currently sorted on so that data in placeholders be correctly shown?

Also is there any other way to achieve the functionality so that data can be shown correctly with interactive sort on?

Re: Capturing the sorted column in a table

ashfaq_haseeb — Tue, 05 Aug 2014 10:41:21 GMT

Hi,

Have a look at below post.

http://community.qlik.com/message/207827#207827

Regards

ASHFAQ

Re: Capturing the sorted column in a table

Thu, 07 Aug 2014 06:39:57 GMT

Hi Ashfaq

The link you shared has contains how to use set analysis to get sum based on ranking of an expression which I have have already used. But in my case the expression on which I have to rank should change based on column I am sorting. I want to identify a way by which I could dynamically change the ranking expression by capturing the column I am sorting on.

Thanks

Himanshu Gupta

Re: Capturing the sorted column in a table

ashfaq_haseeb — Thu, 07 Aug 2014 06:46:58 GMT

Hi.

If you have what news with Qlikview.qvw file

then go through the sales reps tab

Regards

ASHFAQ