Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
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

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

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