aggr result in a text box - Page 2 - Qlik Community

Report Inappropriate Content · ‎2015-01-20

Hello All,

Below is the scenario

There is a date field D1. Each record is to be subtracted from today() and the difference is to be summed up.

The sum is to be shown in a text object.

Please help with the possible solution

Regards,

Priya

Report Inappropriate Content · ‎2015-01-20

Hi All

There are lot many dates and not just two.

However, i got the solution.

=sum(aggr(today()-D1,D1)) .

Previously i was trying with sum first and then aggr on top of it, hence couldnt get the required result.

Thank you for your time.

its_anandrjs · ‎2015-01-20

Hi,

Better you use

=Sum( Aggr( Interval(Today() - D1,'D'), D1))

Regards

Anand