topic Re: Hide Totals Row through VBS? in QlikView

Hide Totals Row through VBS?

Michael_Reese — Wed, 15 Jun 2011 23:12:55 GMT

I am creating a straight table dynamically through the vb script, but can't seem to get rid of the totals row. Any thoughts?

Thanks

Hide Totals Row through VBS?

Michael_Reese — Thu, 16 Jun 2011 19:21:27 GMT

Basically, I need the ability to set the totals mode to no totals on each expression, but I don't see an expression property for that.

Hide Totals Row through VBS?

Michael_Reese — Thu, 23 Jun 2011 13:32:39 GMT

Just checking to see if anyone had any thoughts on this?

Hide Totals Row through VBS?

Anonymous — Fri, 24 Jun 2011 02:05:38 GMT

As far as I can tell you can't control that. You can switch between Expression total and the type of total that you want. BrutalSum decides between Expression Total and the type of total you want, while AggregationMode decides the type of Total:

set chart = ActiveDocument.Sheets("Main").CreateStraightTable

chart.AddDimension "ProductType"

chart.AddExpression "sum(Amount)"

chart.AddExpression "count(Customer)"

set p = chart.GetProperties

p.Expressions.Item(1).Item(0).Data.ExpressionData.BrutalSum = true

p.Expressions.Item(1).Item(0).Data.ExpressionData.AggregationMode = 5 'sum

chart.SetProperties p

Specific aggregation function to be used for totals when BrutalSum=true

0 = Numeric count

1 = Null count

2 = Text Count

3 = Total count

4 = Missing count

5 = Sum

6 = Average

7 = Std dev

8 = Skewness

9 = Kurtosis

10 = Min

11 = Max

12 = Only value

13 = Mode value

14 = First string

15 = Last string

Re: Hide Totals Row through VBS?

Michael_Reese — Fri, 24 Jun 2011 17:01:15 GMT

Yes, I was looking at this. Unfortunately, it doesn't have an option to show 'no totals'.

Hide Totals Row through VBS?

kaushiknsolanki — Fri, 24 Jun 2011 18:51:18 GMT

Hi,

Try below code.

Sub Check

set chart = ActiveDocument.ActiveSheet.CreateStraightTable

chart.AddDimension "Year1"

chart.AddExpression "1"

set cp = chart.GetProperties

set expr = cp.Expressions.Item(0).Item(0).Data.ExpressionData

expr.UsePartialSum = false //To disable the total sum.

chart.SetProperties cp

End Sub

Regards,

Kaushik Solanki

Hide Totals Row through VBS?

Michael_Reese — Fri, 13 Jan 2012 18:25:19 GMT

Thank you!

Re: Hide Totals Row through VBS?

rynedh_blueb — Fri, 18 Jan 2019 18:33:28 GMT

The values for AggregationMode may have changed, in my system "Average" has a value of 3.

Re: Hide Totals Row through VBS?

rynedh_blueb — Fri, 18 Jan 2019 23:18:48 GMT

The resource that I have found most useful is:

https://docs.microsoft.com/en-us/dotnet/api/microsoft.office.interop.excel?view=excel-pia