Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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?

Tags (2)
4 Replies
MVP
MVP

Change the Total Mode default settng by SetProperties

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.

Employee
Employee

Change the Total Mode default settng by SetProperties

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

Change the Total Mode default settng by SetProperties

Thank you very much.

Not applicable

Change the Total Mode default settng by SetProperties

Usefull tips

Community Browser