topic Re: to set a pivot subtotal with macro in QlikView

to set a pivot subtotal with macro

Fri, 25 May 2012 12:34:40 GMT

hi,

It' s possible to set a pivot subtotal with macro?

thank you very much

Re: to set a pivot subtotal with macro

Anonymous — Fri, 25 May 2012 13:05:13 GMT

From the V10 API Guide:

set chart = ActiveDocument.Activesheet.CreatePivotTable
chart.AddDimension "ProductType"
chart.AddExpression "sum(Amount)"
chart.AddExpression "count(Customer)"
set cp = chart.GetProperties
set dims = cp.Dimensions
dims(0).ShowPartialSums = false    'do not show sums
chart.SetProperties cp

You will want to change the dims(0).ShowPartialSums = true

-Phil

to set a pivot subtotal with macro

Fri, 25 May 2012 13:07:01 GMT

Sub SetSubTotalPivotTable

Set c = ActiveDocument.GetSheetObject("CH01")

Set cp = c.GetProperties

Set d = cp.Dimensions

For i = 0 to d.Count - 1

d(i).ShowPartialSums = true

cp.TableProperties.PivotTablePosition = 0

c.SetProperties cp

End Sub

Re: to set a pivot subtotal with macro

Fri, 25 May 2012 13:08:18 GMT

Sub SetSubTotalPivotTable

Set c = ActiveDocument.GetSheetObject("CH01")

Set cp = c.GetProperties

Set d = cp.Dimensions

For i = 0 to d.Count - 1

d(i).ShowPartialSums = true

cp.TableProperties.PivotTablePosition = 0

c.SetProperties cp

End Sub

Re: to set a pivot subtotal with macro

Thu, 29 Nov 2012 11:44:03 GMT

Hello,

I tried it on the V11 but it work but without this line of macro :

cp.TableProperties.PivotTablePosition = 0