Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Can you get the sum of a column in a pivot chart?

Can you get the sum of a column in a pivot chart?

16 Replies
Highlighted
MVP
MVP

Presentation Tab

Select your Dimension and Tick Show partial sum

Highlighted
Not applicable

What if it is an expression?

Highlighted
MVP
MVP

Once you select the above suggested method, it will automatically applied to Expression Total also.

Just try it and let us know if you found any problem.

Highlighted
Not applicable

Is there a way to change the format of a dimension? I have numeric values that I want rounded to a whole number.

Highlighted
Not applicable

how do you want to round them?  The use of ceil() and floor() along with the num functions will take care of that for you

Highlighted
MVP
MVP

Yes,,,

Use calculated Dimensions

NUM(YourDimension,'#,##0')

Highlighted
Employee
Employee

Two ways of doing that

1) go to Document Preferences / Numbers Tab and select/format your dimension

2) Change your dimension into a formatted calculated dimension, eg:  num(yourvalue,"###0.00")

Highlighted
Contributor III
Contributor III

"Show partial Sum" always derives the expression total which is not equal to the sum of rows or columns except if your expression = sum( [fieldName] ) !

Highlighted
MVP
MVP

We can obviously use =SecondaryDimensionality() to get the same...