Discussion Board for collaboration related to Creating Analytics for QlikView.
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"
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?
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.
The setting you want is cp.Expressions.Item(1).Item(0).Data.ExpressionData. UsePartialSum = falseBrutalSum is to distinguish between the different ways to calculate the total ("Expression Total" and "Sum/Average... of Rows"
Thank you very much.