topic Re: Above Aggr issue in QlikView

Above Aggr issue

steeramp — Wed, 25 Nov 2020 16:16:04 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

pooja_prabhu_n — Mon, 30 Jul 2018 10:21:14 GMT

Hi,

Calculate the days difference in the script level.

if(Absence_Emp=Peek(Absence_Emp),Date_Absence- Peek(Date_Absence),0) as Days_diff

Directly use Sum(Days_diff) in the Text box.

as far as i know, use of Above function directly won't work in Text box.

Thanks,

Pooja

jyothish8807 — Mon, 30 Jul 2018 10:24:20 GMT

Hi Steeven,

Please find attached.

Br,