topic Pivot Table Controls in QlikView

Pivot Table Controls

pover — Thu, 03 Sep 2009 10:09:01 GMT

Is there a way to expand all and collapse all in a pivot table by using a macro. I've searched the API Guide, but I haven't found anything.

Has anybody tried to make 3 separate pivot or straight tables behave as if it were one table using macros?

Thanks,

Karl

Pivot Table Controls

Thu, 03 Sep 2009 11:46:25 GMT

hey Karl!

give this a try:


sub toggle_expand()

 set chart = ActiveDocument.GetSheetObject("CH1324")
 set gp = chart.GetProperties

 gp.TableProperties.PivotAlwaysFullyExpanded = not gp.TableProperties.PivotAlwaysFullyExpanded
 chart.SetProperties gp

end sub

Pivot Table Controls

Anonymous — Thu, 03 Sep 2009 20:35:44 GMT

This is what I used to collapse or expand all:


sub CollapsePivot
 on error resume next
 set chart = ActiveDocument.GetSheetObject("CH01")
 chart.CollapseLeft 0,0,true
end sub
sub ExpandPivot
 on error resume next
 for n = 0 to 5 ' number of dimensions was 5
 set chart = ActiveDocument.GetSheetObject("CH01")
 chart.ExpandLeft 0, n, true
 next
end sub

Didn't work in QV8.50. Should be OK in 9

Pivot Table Controls

anitamelbye — Mon, 26 Apr 2010 09:37:11 GMT

Hi,

I can not get this to work. Can someone please be helpfull and explain to me what I am doing wrong?

I would like to make an expand all button, and I have changed the numer of dimension to 7 (the number of dimensions I have), and I have changed the "CH01" to "CH02". Am I suppose to remove the ""? What else am I suppose to change?

I am sorry to say, I don't know any macro-programming, so I am so very thankful for all your help 🙂

*newbee in love* 🙂

Pivot Table Controls

Anonymous — Mon, 26 Apr 2010 14:52:07 GMT

Anita,
Your certainly should not remove "". The reason ofornot working could be QlikView version. These macros don't work in some versions, I can't tell now which ones, sorry.

Pivot Table Controls

anitamelbye — Tue, 27 Apr 2010 05:50:04 GMT

Thank you for responding Michael!
I'm on version 9.00.7320.7 SR2.

If Michael does not have an answer maybe no one else does either? 🙂
I really would like to get this "Expand All"-button to work.. Hmm..

*newbee in love*