Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Want to add more than 9 dimensions in pivot table

Hi All,

         I have 20 dimensions in my excel sheet. I used Pivot table Concept but it allows only 9 dimensions.Please help me how to add more dimensions in pivot table.

Thanks,

Shonasen

5 Replies
tyagishaila
Specialist
Specialist

You can try customized table method to show all 20 dimensions, but show max 9 at a time.

Customizable Straight Table

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

A pivot table can have as many dimensions as you want. But each dimension you add will make the pivot table slower. I have no problem creating a pivot table with a dozen dimensions. Can you post a qlikview document that demonstrates the problem?


talk is cheap, supply exceeds demand
Not applicable
Author

I tried to use pivot table in Qlik Sense not in QlikView.

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Then you posted in the wrong forum. No problem, but it's why I assumed you're using QlikView. Please your question post in the Qlik Sense forums.


talk is cheap, supply exceeds demand
Not applicable
Author