Solved: pivot table expand columns - Qlik Community

Louveduval · ‎2025-02-13

Hello,
I'm sorry to bother you but, do you have an tips to expand until thetargeted column.
I've a pivot table with many columns , and want to expand all lignes until the third column for exemple and not clik on all lignes for that.

Can you help me ?

rubenmarin · ‎2025-02-13

Hi, I would like this would be as easy as it was on QlikView but for some reason it's still not availbale, you can support the idea here: https://ideation.qlik.com/app/#/case/279040

As a workaround you can set the 'show colum if' option with a combination of a dimension selector or a variable that set the number of the visible dimensions. Hiding the dimensions you don't want to use you can use the option to expand all.

View solution in original post

rubenmarin · ‎2025-02-13

Hi, I would like this would be as easy as it was on QlikView but for some reason it's still not availbale, you can support the idea here: https://ideation.qlik.com/app/#/case/279040

As a workaround you can set the 'show colum if' option with a combination of a dimension selector or a variable that set the number of the visible dimensions. Hiding the dimensions you don't want to use you can use the option to expand all.

rubenmarin · ‎2025-04-25

Hi, few weeks ago the pivot table on the visualization bundle added the option to expand or collapse to a column: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Visualizations/Visualiza...

Louveduval · ‎2025-04-25

Hello,
thank you very much for the news !!!

But it's not very practical in this pivot bundle we haven't the list of the dimension

for example here we can't see that we have 5 others dimensions

But it's better than extend all the table 🙂

Best regard 🙂

pivot table expand columns

General Question

Visualization