topic Change the Total Mode default settng by SetProperties in QlikView

Change the Total Mode default settng by SetProperties

Thu, 10 Mar 2011 12:35:02 GMT

set expr2 = cp.Expressions.Item(1).Item(0).Data.ExpressionVisual
expr2.Label.v = "UOM"
expr2.(**** need help for Total Mode default setting change *****)= 'No Totals'
set dims = cp.Dimensions
dims(0).Title.v = "CUSTOMER"
dims(1).Title.v = "LOCATION"
dims(2).Title.v = "ITEMNUMBER"

obj.SetProperties cp

I am trying to change the Total Mode setting in Straight Chart Properits to 'No Totals' instead of 'Expression Total' as default by macro. Could someone fill the third line mentioned above?

Change the Total Mode default settng by SetProperties

Miguel_Angel_Baeyens — Thu, 10 Mar 2011 12:57:37 GMT

Hello,

Instead of that third line, you will have to use something similar to this one

cp.Expressions.Item(1).Item(0).Data.ExpressionData.BrutalSum = false '' "No Totals"

Note that it's not a member of ExpressionVisual but ExpressionData.

Hope that helps.

Change the Total Mode default settng by SetProperties

kji — Thu, 10 Mar 2011 14:00:16 GMT

The setting you want is

 cp.Expressions.Item(1).Item(0).Data.ExpressionData. UsePartialSum = false

BrutalSum is to distinguish between the different ways to calculate the total ("Expression Total" and "Sum/Average... of Rows"

Change the Total Mode default settng by SetProperties

Thu, 10 Mar 2011 15:27:05 GMT

Thank you very much.

Change the Total Mode default settng by SetProperties

Mon, 09 Jan 2012 07:45:17 GMT

Usefull tips