Wrong Sum in Table

[beck_bakytbek]

Hi Folks,

i got a question (please see attached screenshot):

For my Project C in Column: New_Expression i created the following expression: if(sum(Actual) = 0, sum(Plan), sum(Actual)) this expression does work. 

But as total Sum i have only 20 instead 40, i am using in this case the straight table. My expected Output is: Sum = 40

Does anobody know how to resolve this issue.

Thanks a lot in advance for any suggestions and feedbacks

Bek

[lironbaram]

Hi , 

Qlik engine is calculating the total in app level using the expression, it doesn't sum the rows 
so in your case on app level sum(Actual)>0 so you get 20 as the total 
you need to change the total function in the measure from Auto to Sum 

[beck_bakytbek]

Hi Lironbaram, first of all thanks a lot for your time and help, Yes it is a good suggestion. I wanted to know, is that possible to resolve this issue maybe by using of functin: Aggr ().

Do you have any idea?

Thanks a lot

[lironbaram · Accepted solution]

yes you can do it with aggr() function 

sum(aggr( if(sum(Actual) = 0, sum(Plan), sum(Actual)),Project))

[beck_bakytbek]

Hi Lironbaram, thanks a lot for your help and time