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

Expression total is not actually displaying sum of all values

Hi dudes,

I have 1 dimension and 1 expression.

I have bar chart which can be changed o pivtot table.

the individual monthly values on bar chart/pivot table are correct.

but on left corner  over bar chart/pivot table; we can see 3751 as total. it is wrong. sum of all individual values of all months gives 3768.

can any 1 tell me how to make 3768 get displayed and wat is going wrong?

also i am attaching qvw.

1 Solution

Accepted Solutions
sunny_talwar

Try this as your expression:

Sum(Aggr(YourCurrentExpression, YourChartDimensions))

View solution in original post

6 Replies
sunny_talwar

Try this as your expression:

Sum(Aggr(YourCurrentExpression, YourChartDimensions))

qlikmsg4u
Specialist
Specialist

PFA

Not applicable
Author

can u tell me wats the reason and how it is working?

Not applicable
Author

hey kn ..this is wat sunny has posted....it is wrking. can u tell me wat is the reason?

Not applicable
Author

Hi Prudhvi,

the total of 3751 is the correct value for the expression, the expression total isn't affected by your dimension and so if you look at your whole data set and count the number of distinct employee numbers terminated in 2014 it is indeed 3751. This number doesn't count employees which are terminated multiple times in different months.

Employee 34149 for example was terminated in Feb and Mar, so will count in your bar chart twice, one for each month. However will only count a single time in the expression total.

The answer Sunny provided ensures your dimension is taken into account and so counted twice, like how you expect it to.

Hope that helps explain

Joe

Not applicable
Author

Nice....Dude Thanks alot