Wrong output of Sum in Graph

[#1]

Hi Qlikview Community,

Can some one explain this to me? It always happen. The total always not equal. I always not use Sum() function because it give me wrong output, I forgot the expression I use on the graph is Sum({<penalty={"<=0"}>}[curr-assess]), i allows not to graph those who has 0 penalty which is I need to display.

Help me to make the total in graph the same in the table below.

Thanks in advance Qlikview Community.

[#2]

Hi sir Ravichandra,

That one sir, how did you do that? can you tell me what did you do to get that result?

[#3]

Hi sir Vinod,

the result is the same when i use it on the Expression.

By the way, thanks for sharing your idea

[#4]

Hi sir Jonathan,

Thank for correcting me, but I dont know how to attach the qvw and also the qvd of my activity.

[sasiparupudi1 · Accepted solution]

[#6]

Hi Qlikview Community,

Thanks for sharing me your ideas and giving advice.

I use this expression:
Sum({<penalty={"<=0"}, qtr1={1,2,3,4}>}[curr-assess])/2

because it doubles the sum that is why I will divide it into 2
and i get the result right LOL

Btw, thank you all