topic Re: Pivot table in QlikView

Pivot table

Fri, 06 Dec 2013 07:11:32 GMT

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

Re: Pivot table

vikasmahajan — Fri, 06 Dec 2013 07:36:15 GMT

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

Re: Pivot table

Fri, 06 Dec 2013 07:39:22 GMT

Hi Tamil

It is not possible

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

Ananth

Re: Pivot table

Fri, 06 Dec 2013 07:40:43 GMT

Hi vikas

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