topic Re: help - aggr function in QlikView

help - aggr function

Wed, 04 Jul 2012 11:22:04 GMT

Dear All,

I need to calculate the sum(amount) only ID's having selected date - max(date) is less than or equal to 556.

PFA.

thanks in advance

swuehl — Wed, 04 Jul 2012 11:50:10 GMT

Try

=sum(aggr(if(Today()-max(DMonthEnd)<=556, sum(Amount)),ID))

this will return a higher amount than given by you, since also IDs 7,8,10 are fulfilling the requirement.

Hope this helps,

Stefan

edit:

This set expression should also work:

=sum({<ID = {"=today()-max(DMonthEnd) <=556" }>}Amount)

sathishkumar_go — Wed, 04 Jul 2012 14:03:01 GMT

HI Gopi, Please find the attachments. I hope this will helpful for you. Regards Sathish

Thu, 05 Jul 2012 03:42:37 GMT

thank you swuehl,sathish,

i tried the delow expression, its working fine.

=sum({<ID={"=today()-max(DMonthEnd)<=555"}>}Amount)