Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I all
i'm new of qlik if someone help me pleas
I would like have a total amount with condition
Example
Month, Budget, Sales
Gen,100.25
Feb,100,25,
Mar,100,0
Apr,100,0
etc
The total that i would like obtain is 250.
I used the follow expression but the total that i obtain is 400 or 50
if (sum(Sales)>0,sum(Sales), sum(Budget) )
Many thanks
PT
Hi,
Use this expression.
sum(aggr(if(sum(Sales)>0,sum(Sales), sum(Budget)),Mese))
Regards,
Kaushik Solanki
try this
if (sum(Sales)>0,sum(Sales) + sum(Budget), sum(Budget)
)
hope it helps
Hi,
Use this expression.
sum(aggr(if(sum(Sales)>0,sum(Sales), sum(Budget)),Mese))
Regards,
Kaushik Solanki
No in this case the total is the sumo of both colums (total 450)
I wold like sum sales if exist otherwise sum budget
Thanks
No in this case the total is the sumo of both colums (total 450)
I wold like sum sales if exist otherwise sum budget
Thanks
No in this case the total is the sumo of both colums (total 450)
I wold like sum sales if exist otherwise sum budget
Thanks
Try the one i had shown in above post.
Regards,
Kaushik Solanki
Many thanks
now work perfectly