Pivot Table with some rows expanded and others not
I am having an issue with a pivot table. When the page is loaded on server, for some rows, it is expanded as shown in the prinstcreen "DOA not showing.png". Even though it is fully expanded, The + sign is still displaying. I would like to have the pivot table expansions to be collapsed on loading. The properties "show as fully expanded" is already unselected for the pivot table.
I would like to know if it is possible to solve this issue.
For this i didnt completely understood your issue, but still you can save the published app from the Qlikview desktop by doing the pivot fully collapsed. So that it always be collapsed at the loaded time for the user.....
When you click and collapse a higher level column in a pivot table, QlikView seems to store the level at which the underlying columns are expanded, so when you click to expand one column, sometimes more than one column will expand.
You can reset this by collapsing each column individually.