topic Above Aggr issue in QlikView

Above Aggr issue

steeramp — Mon, 30 Jul 2018 09:32:01 GMT

Hello ,

I have an issue , I want to sum numbers of days between "Date absence" , Example

employe 349 : ( ("08-02-2018" - "01-02-2018") = 7days + ("13-02-2018" - "08-02-2018") = 5days) = 12days

employe 395 : ("16-02-2018" - "15-02-2018") = 1days

employe 433 : ("27-02-2018" - "26-02-2018") = 1days

employe 533 : ("15-02-2018" - "14-02-2018") = 1days

What I want to have report in one TEXT BOX the sum of this values .... then 15 days

How I can do this ? THANKS SO MUCH

YoussefBelloum — Mon, 30 Jul 2018 10:09:45 GMT

Hi,

Interesting.. but don't think it is possible directly on a text object without some calculations on the script..

Maybe stalwar1‌ can take a look here ?

sunny_talwar — Mon, 30 Jul 2018 11:08:22 GMT

May be this

=Sum(Aggr(Max(Date_Absence) - Min(Date_Absence), Emp))