topic Re: How to collapse all dimensions? in QlikView

How to collapse all dimensions?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have pivot chart that looks like this. QV seems to remember the last "state" I was in.

My question is how do I collapse all the dimensions back to the "FiscalYear" level (see 2nd screenshot)

every time I click on this sheet? I don't want the "state: to be remembered.

Thank you.

Re: How to collapse all dimensions?

krishnacbe — Mon, 24 Oct 2016 14:23:18 GMT

Hi,

Try with below option

Presentation Tab -> Uncheck Always Fully Expanded check box.

Re: How to collapse all dimensions?

t_moutault — Mon, 24 Oct 2016 14:26:14 GMT

Hi,

try sheet properties -> Trigger

Re: How to collapse all dimensions?

Anonymous — Mon, 24 Oct 2016 14:28:35 GMT

The "Always Fully Expanded" was already unchecked.

Re: How to collapse all dimensions?

Anonymous — Mon, 24 Oct 2016 14:32:34 GMT

Thomas,

Adding a trigger to minimize the object simply minimizes my chart when I click on the sheet. So this is not what I want.

I just wanted to collapse the dimensions.

Re: How to collapse all dimensions?

jyothish8807 — Mon, 24 Oct 2016 14:41:25 GMT

Hi Sydney,

Try the below macro. It will expand your pivot permanently. i am working on to make it more flexible.

run this macro on sheet open trigger.

Sub ExpandChart2

On Error Resume Next

set vUN = ActiveDocument.Variables("vUserName")

set vFilePath = ActiveDocument.Variables("vFilePath")

Set vChartToExpand = ActiveDocument.Variables("vChartToExpand")

Set chart = ActiveDocument.GetSheetObject(vChartToExpand.GetContent.String)

Set gp = chart.GetProperties

gp.TableProperties.PivotAlwaysFullyExpanded = TRUE

chart.SetProperties gp

set obj = ActiveDocument.GetSheetObject("CH01")

End Sub

Regards

Re: How to collapse all dimensions?

Anonymous — Mon, 24 Oct 2016 14:46:45 GMT

Hi Jyothish,

Thanks for the code. But I'm looking to collapse the dimensions (again, see 2nd screenshot) and not

to expand them. Do you have code to do "collapsing"? Thanks!

Re: How to collapse all dimensions?

rupamjyotidas — Mon, 24 Oct 2016 14:52:58 GMT

Try this through AccessPoint every time you login

Re: How to collapse all dimensions?

Anonymous — Mon, 24 Oct 2016 14:53:52 GMT

I found this post but it's a user driven action.

Expand all the dimensions - Pivot Table

Right click on dimension -> choose expand / collapse.

Anyone knows the code/macro behind this event?

Re: How to collapse all dimensions?

Anonymous — Mon, 24 Oct 2016 14:54:59 GMT

Does this only affect my account? What about the users?

Re: How to collapse all dimensions?

rupamjyotidas — Mon, 24 Oct 2016 14:56:37 GMT

It will only clear the state of your app. not the other Users. If they want, they need to do the same every time they log in.

You can also change the server settings , so that it doesn't save any state

Re: How to collapse all dimensions?

Anonymous — Mon, 24 Oct 2016 14:59:33 GMT

I prefer the solution to be on the client side vs. backend. So if there's some type of macro (or code) to do this, this would ideal for me.

Re: How to collapse all dimensions?

Anonymous — Mon, 24 Oct 2016 18:58:47 GMT

I've spent a couple of hours researching for a solution, it does not appear QV can do what I'm asking. I saw this same question being asked a few years back on this forum. If anyone has written a macro (or code) to mimmick right click on chart header -> Collapse All, please post.

Thanks!

Re: How to collapse all dimensions?

Anonymous — Mon, 24 Oct 2016 20:53:26 GMT

Does this help you?

Re: How to collapse all dimensions?

Anil_Babu_Samineni — Tue, 25 Oct 2016 01:47:04 GMT

I don't think so Qlikview has this future. But, gurus or supported emp's can help us

Re: How to collapse all dimensions?

Anonymous — Tue, 25 Oct 2016 14:38:09 GMT

Hi Marcio,

Thanks for sharing the code. Unfortunately this isn't exactly what I was looking for. It's a nice piece of coding

for hiding/unhiding everything.

Re: How to collapse all dimensions?

Anonymous — Tue, 25 Oct 2016 14:47:39 GMT

I'm sorry, the intention was to really help.

Re: How to collapse all dimensions?

Peter_Cammaert — Tue, 25 Oct 2016 15:09:55 GMT

Define a bookmark for a collapsed pivot. Include the layout state, but do not include any selections.

Load this bookmark by triggereing an action everytime you enter the sheet.

Re: How to collapse all dimensions?

Anonymous — Tue, 25 Oct 2016 15:15:35 GMT

Peter,

That's exactly what I was playing around with yesterday. I had it working but realized I ended up having two buttons per chart. One button to expand and another to collapse. I didn't like having 4 buttons occupying the screen just to do this. I'd rather ask the users to right click on the chart -> click expand/collapse.

Re: How to collapse all dimensions?

Peter_Cammaert — Tue, 25 Oct 2016 15:18:59 GMT

You can reduce the number of buttons by setting a variable when applying each of two bookmarks (expand/collapse) and hiding "the other" button. If you put them in the same place, the use of these buttons will be intuitive.

To make it more clear what state is currently displayed, and what the button will do, you can design it with a plus sign or a minus sign in the center.