Counting Days in specific range

Battistella — Thu, 03 Mar 2022 14:45:44 GMT

Hello,

I am creating a tool that counts days within a specific range of time.

I have a database of people who took a leave of abscence from work, for example:

See that I have a lot of short periods of time, and I need to filter a specific range such as:

(format being: dd/MM/yyyy)

The problem is there are some periods of time that begins before that range, but ends between it, or that starts between and ends after. Therefore my counter is adding the full days. For example:

John took a leave of abscense from o5/03/2021 to 25/03/2021

I need to see how many days off he was from 15/03/2021 to 15/04/2021

It is suppose to be =10, but it is resulting 30.

I don't know if i could explain my problem, any doubts just ask me.

Thank you all

Re: Counting Days in specific range

hic — Thu, 03 Mar 2022 16:31:05 GMT

You need to generate all dates in the range, and then just use

Count(ReferenceDate)

as measure. See more on https://community.qlik.com/t5/Qlik-Design-Blog/Creating-Reference-Dates-for-Intervals/ba-p/1463944

topic Counting Days in specific range in App Development

Counting Days in specific range

Re: Counting Days in specific range