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.
.png "Luminary Alumni"){kind=icon}
