topic Re: How to sum the an expression with aggregates in QlikView

How to sum the an expression with aggregates

Anonymous — Wed, 15 Apr 2015 09:39:46 GMT

Hi everyone.

So the following expression of mine shows a 1 if the value is bigger than 0, and a 0 if not.

=if((sum(aggr(sum([Stk Adj Qty]),[SK Branch No])) + sum(aggr(sum([Inflow Qty]),[SK Branch No]))) > 0 , 1 ,0)

basically what it does it to check if the sum of Stk Adj Qty and Inflow Qty is bigger than 0 with branch as dimension

What I'd like to do is to sum all those 1's together to give me a total on the caption of the object, but it just wont work.

Any idea on what I'm doing wrong?

Thank you guys

Re: How to sum the an expression with aggregates

awhitfield — Wed, 15 Apr 2015 09:41:14 GMT

Hi Stefan,

can you post your app please?

Andy

Re: How to sum the an expression with aggregates

Wed, 15 Apr 2015 09:58:19 GMT

Hi,

Try to check result of following exp in yur app,

=sum(aggr(sum([Stk Adj Qty]),[SK Branch No])) also,

=sum(aggr(sum([Inflow Qty]),[SK Branch No])))

& see whether it is working properly or not else your exp looks correct...

Re: How to sum the an expression with aggregates

jonathandienst — Wed, 15 Apr 2015 10:01:29 GMT

=Sum(Aggr(if((sum(aggr(sum([Stk Adj Qty]),[SK Branch No])) + sum(aggr(sum([Inflow Qty]),[SK Branch No]))) > 0 , 1 ,0), <table dimensions>))

where <table dimensions> is a comma separated list of the table dimensions

HTH

Jonathan

Re: How to sum the an expression with aggregates

sunny_talwar — Wed, 15 Apr 2015 10:26:04 GMT

or another alternative would be, if it is a straight table that you are using, is to use the QlikView inbuilt total mode. You can select Sum and it should sum the expression you had initially

=if((sum(aggr(sum([Stk Adj Qty]),[SK Branch No])) + sum(aggr(sum([Inflow Qty]),[SK Branch No]))) > 0 , 1 ,0)

I hope this helps.

Best,

Sunny

Re: How to sum the an expression with aggregates

shambhub — Wed, 15 Apr 2015 10:34:47 GMT

Stefan,

Try like this

=sum(if((sum(aggr(sum([Stk Adj Qty]),[SK Branch No])) + sum(aggr(sum([Inflow Qty]),[SK Branch No]))) > 0 , 1 ,0))

Best Regards

Shambhu B