topic Re: Counting days in QlikView

Counting days

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

How can I count the number of days between two dates?

I have ClaimDate and ConcludedDate and I want to count the number of days in between.

prashanth1712 — Tue, 16 Aug 2016 13:13:54 GMT

Hi,

U can use like (ConcludeDate - ClaimDate)

thanks

arulsettu — Tue, 16 Aug 2016 13:16:34 GMT

try this

NetWorkDays(ClaimDate ,ConcludedDate )

Anonymous — Tue, 16 Aug 2016 13:24:37 GMT

I tried to put this in a KPI, but it did not work. Does anyone have another idea?

reshmakala — Tue, 16 Aug 2016 13:24:53 GMT

If you want to calculate all days in between dates, then you can use

ConcludedDate - ClaimDate

If you want to calculate only working days (Monday-Friday), then use

Networkdays (ClaimDate , ConcludedDate )

hubertdudek — Tue, 16 Aug 2016 14:18:30 GMT

Floor(ConcludedDate) - Floor(ClaimDate)

Anonymous — Tue, 16 Aug 2016 15:13:40 GMT

Try it.

=Floor(Interval(ConcludedDate-ClaimDate,'DD'))

Regards.