Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

help - aggr function

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

3 Replies
swuehl
MVP
MVP

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
Partner - Specialist
Partner - Specialist

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

Not applicable
Author

thank you swuehl,sathish,

i tried the delow expression, its working fine.

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