Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Partner
Partner

Above Aggr issue

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 MUCH2018-07-30_11-15-15.png

Tags (2)
2 Replies
YoussefBelloum
Esteemed Contributor

Re: Above Aggr issue

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 ?

Re: Above Aggr issue

May be this

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


Capture.PNG