topic Re: Pivot table is not getting collapse. in QlikView

Pivot table is not getting collapse.

Fri, 31 Jan 2014 10:48:37 GMT

Hi All,

I am using Pivot Table, Charts etc in my App.

On Clicking CLEAR button, Every object is getting cleared.

Pivot table is not getting collapse.

I think, by default it should collapse on clicking. Don't know why.

Can anyone help me with this ?

Regards,

Praveen

Re: Pivot table is not getting collapse.

Anonymous — Fri, 31 Jan 2014 10:51:02 GMT

I think if you clear your selections the pivot table returns to the previous level of expansion before you made the selection

Re: Pivot table is not getting collapse.

Fri, 31 Jan 2014 10:52:41 GMT

Hi Adrian,

Its not happening. That's my issue.

Re: Pivot table is not getting collapse.

Anonymous — Fri, 31 Jan 2014 10:56:11 GMT

Do you have 'Always Fully Expanded' ticked in the Presentation tab?

Re: Pivot table is not getting collapse.

Fri, 31 Jan 2014 11:00:50 GMT

by clicking on CLEAR button, pivot table will not collapse or Expand.

U have to right click pivot table and use Expand All or Collapse All

Re: Pivot table is not getting collapse.

Fri, 31 Jan 2014 11:00:53 GMT

Adrian,

No. I have not selected that option. If that is the case, I wont be able to Collapse even manually ryt ?

Initially while opening the dashboard, it is in collapsed state only.

But after selecting it and expanding it, once if I click CLEAR, all objects are resetting except Pivot table.

Re: Pivot table is not getting collapse.

Fri, 31 Jan 2014 11:08:18 GMT

If you want pivot table to collapse on clicking on CLEAR button, then create 2 pivot table display one with variable, after viewing once u click on CLEAR assign a variable to bring the other pivot table whcih is collapsed.

It is a work around ...

Re: Pivot table is not getting collapse.

Mon, 03 Feb 2014 06:54:51 GMT

Thanks Nagaraj.