topic Re: Sum of total dates between dates (overlap dimension) in QlikView

Sum of total dates between dates (overlap dimension)

Wed, 24 Jun 2015 16:45:54 GMT

Hello

I have the following table:

I want to put on the text box the total days between the DATE_UP and today.

In this example the result must be equal to 250

Resulting of the sum: 71 (14/04/2015 to Today) + 43 (12/05/2015 to Today) + 113 (03/03/2015 to Today) + 23 (01/06/2015 to Today)

Thanks in advance for your help

Gysbert_Wassenaar — Wed, 24 Jun 2015 17:02:37 GMT

Try sum(rangesum(today(), -DATE_UP))

swuehl — Wed, 24 Jun 2015 17:06:23 GMT

I do get a slightly different sum (maybe you are ahead of time?),but I think you should get what you want by using

=sum(aggr(today()-DATE_UP, STORE_ID))

edit:

Gysbert is right, you don't need advanced aggregation here:

=sum( today() - DATE_UP)

Wed, 24 Jun 2015 18:17:54 GMT

You Can use something like this

SUM(Ceil(Interval(Date#(today(), 'M/DD/YYYY') - Date#(DATE_UP, 'DD/MM/YYYY'), 'DD' )))