Expression total is not actually displaying sum of all values

[#1]

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.

[sunny_talwar · Accepted solution]

Try this as your expression:

Sum(Aggr(YourCurrentExpression, YourChartDimensions))

[qlikmsg4u]

PFA

[#4]

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

[#5]

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

[#6]

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

[#7]

Nice....Dude Thanks alot