topic Re: Sorting pivot tables (New Vizlib pivot table) in App Development

Sorting pivot tables (New Vizlib pivot table)

Anonymous — Wed, 04 Jul 2018 22:21:29 GMT

Hello all,

I'm looking for a fully sortable pivot table but haven't had any luck. Ideally, a user in the visualization mode could sort by any of the columns, in either ascending/descending order. For example, one user might want to sort the table by the second column ("fatos velhos") in ascending order while a different user may want to sort the table by the last column ("orçamento final") in descending order:

Using the standard Qlik pivot table, I can "pre sort" the table a certain way but once I visualize the table, I can't change the order.

I just downloaded the new Vizlib pivot table and unfortunately I've got the same problem.

With the Vizlib straight table, I can enter the vizualization mode and sort by any column simply by clicking on the headers:

Column "Valor" Ascending

Column "Valor" Descending

However, the headers in both the standard pivot table and the Vizlib version aren't "clickable".

Has anyone seen a solution to this problem (or maybe a good extension)? Am I simply missing something obvious?

It seems like a pretty glaring flaw to not be able to sort a pivot table in vizualization mode. It's for a client meeting that needs to be dynamic ("now let me see who has the biggest X"), and the inability to sort is making it so Qlik loses out to a good old Excel spreadsheet.

Re: Sorting pivot tables (New Vizlib pivot table)

simondachstr — Wed, 18 Jul 2018 15:24:23 GMT

In the Vizlib Pivot Table, you can sort by dimensions but not yet by measures. This will be made available in the next releases in the coming weeks. Stay tuned!

Re: Sorting pivot tables (New Vizlib pivot table)

saradhakishore — Wed, 10 Apr 2019 10:08:15 GMT

Hi Iam facing the same problem .I want to get the Top N values for which I have a filter with values namely ,Top 5 ,top 10 , Top 25 ETC .I have introduced rank field into the pivot table so that a condition can be used to link the filter and the pivot table fields .But I dont know how to put this in qliksense and where to .

Please help.Stuck with this for a couple of weeks .

Re: Sorting pivot tables (New Vizlib pivot table)

patricesalem — Mon, 16 Dec 2019 22:42:00 GMT

Hi Simon

The few weeks have gone for a longtime...any plan for the next updates ? (sort by measure)

thanks

Re: Sorting pivot tables (New Vizlib pivot table)

robert99 — Tue, 17 Dec 2019 05:59:04 GMT

One way of sorting the standard Pivot Table

https://www.youtube.com/watch?v=iiMlRVJWmsk