Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
yes you can do it with aggr() function
sum(aggr( if(sum(Actual) = 0, sum(Plan), sum(Actual)),Project))
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
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
yes you can do it with aggr() function
sum(aggr( if(sum(Actual) = 0, sum(Plan), sum(Actual)),Project))
Hi Lironbaram, thanks a lot for your help and time