Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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!
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 .
Hi Simon
The few weeks have gone for a longtime...any plan for the next updates ? (sort by measure)
thanks
One way of sorting the standard Pivot Table