Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
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
MVP
MVP

Re: help - aggr function

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)

Highlighted
Partner
Partner

Re: help - aggr function

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

Not applicable

Re: help - aggr function

thank you swuehl,sathish,

i tried the delow expression, its working fine.

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