topic aggr vs total in QlikView

aggr vs total

Wed, 05 Dec 2012 07:55:29 GMT

Hi!

A have table (please see atachment) and expression:

=if(month = '201211',sum( TOTAL {<month={'201211','201210','201209'}>}Sale),0)

I have problem with my formula. When i select only one country it works, when several - i have total sum.

i trying use aggr function like this:

=if(month = '201211',aggr(sum( {<month={'201211','201210','201209'}>}Sale),Country),0)

but it it not working

i need sum 3 month sale by Country

Please help if you can

perumal_41 — Wed, 05 Dec 2012 08:36:22 GMT

Hi,

I attached one application please find out

Wed, 05 Dec 2012 09:13:32 GMT

Hi, Perumal!

Thank you for help.

In attachment sum is correct, but i need it apear with '201211'.

is it posseble?

perumal_41 — Wed, 05 Dec 2012 09:18:43 GMT

Try this expression

Sum( {<month = {'201211'}>} aggr(NoDistinct sum( {<month={'201211','201210','201209'}>}Sale),Country))

Wed, 05 Dec 2012 09:20:43 GMT

Thank you!!!

it works perfectly