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

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Allow pivoting to only few dimensions

Hi All,

I have a requirement where only first three dimensions has to be allowed for pivoting.

Once first three is allowed the other dimensions should expand automatically.

Please help me with that. It would be helpful if i can get any such examples.

Regards,

Keerthi KS

Labels (1)
3 Replies
sujeetsingh
Master III
Master III

I do not think that Pivot table in Qlikview provide such tuning. Well You can expand the dimensions and collapse those not needed and save the file it that mode.

Not applicable
Author

Yeah we can do that way. Can we remove '-' sign for those expanded ?? and they should not be able to collapse again

marcus_sommer
MVP
MVP

It's not possible - pivoting is a global option and there is also no function to get the informations if any column is expended or collapsed. But I think you could get good visualizations and usability if you used several objects for it - maybe combined within a container.

- Marcus