topic Re: Pivot table sorting by column header in App Development

Pivot table sorting by column header

DGO — Fri, 03 Jan 2020 18:26:20 GMT

I have a pivot table with 2 dimensions (Customer Name and internal company) and 2 measures (2019 and 2020 sales).

How can I allow the user to sort the pivot table by measure? Intuitively, they should be able to click the column header to sort like on straight tables.

Re: Pivot table sorting by column header

robert99 — Sat, 04 Jan 2020 03:42:15 GMT

Hi @DGO

This is what I use

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

Re: Pivot table sorting by column header

DGO — Sat, 04 Jan 2020 05:43:35 GMT

Thank you for this solution. It’s not as clean as I would like it to be. This is a necessary function and should be a standard function of the pivot table chart.

If anyone from Qlik reads this, please make this a standard feature of the pivot table chart. I’m sure many others would also appreciate it.