Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Yeah we can do that way. Can we remove '-' sign for those expanded ?? and they should not be able to collapse again
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