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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2013-12-06 02:11 AM

Pivot table

Hi All,

I need to freeze the expand / collapse option for particular dimension in pivot table.

For example:

I m having 4 Dimensions like Region,Country, state,city in one pivot table and No of peoples in expression . I want to expand and collapse state and city only. Region,Country and state remains fuly expanded mode.

Can anyone tell is it possible ? and any idea for this?

Thanks in Advance

475 Views
0 Likes
3 Replies
vikasmahajan
MVP
MVP
‎2013-12-06 02:36 AM

IT is  possible  you do one thing  collapse state and city and expand Region , Country and SAVE  Qvw file

when user will see  , it will be in that fashion only.

Good Luck

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
413 Views
0 Likes
Not applicable
‎2013-12-06 02:39 AM
Author

Hi Tamil

It is not possible

we have only one option in presentation tab & check the "Always Full Expanded" option.

Ananth

413 Views
0 Likes
Not applicable
‎2013-12-06 02:40 AM
Author

In response to vikasmahajan

Hi vikas

It is manual thing only there is no particular option for restrict expand & Collapse for some particular dimension

413 Views