Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Change the Total Mode default settng by SetProperties

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?

4 Replies
Miguel_Angel_Baeyens

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.

kji
Employee
Employee

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"
Not applicable
Author

Thank you very much.

Not applicable
Author

Usefull tips