topic Re: Counting customers if they fall within time frame in QlikView

Counting customers if they fall within time frame

rtr13 — Sat, 16 Nov 2024 00:31:58 GMT

Hi All,

I am having some troubles putting an expression together for one of my projects. Within one row of data, there are two separate dates, a start and end date in addition, there is a field that indicates if a customer is active or inactive. My end goal is to have a dynamic expression that if a customer is active within the date frame that an end user selects, is counted within the expression.

Re: Counting customers if they fall within time frame

Taoufiq_Zarra — Fri, 05 Jun 2020 17:13:35 GMT

can you share a sample data and the expected output ?

Re: Counting customers if they fall within time frame

rtr13 — Fri, 05 Jun 2020 19:52:37 GMT

Unfortunately I do not have any sample data. Based on dynamic date fields, when selected, if the selected date field falls between their start and end date they should be counted within the measure.

For example say a customers start date is 02/01/2019 and their end date is 05/01/2020 and the field being used for filters is Order date, when an end user chooses a order date within that time frame, the customer should be counted. But, when outside the start and end date, the customer should not be counted. I hope this makes it more clear on what I am trying to accomplish.

Another thing that may be important is that a customer can have multiple separate start and end dates (it's historical data I'm working with).

Re: Counting customers if they fall within time frame

Taoufiq_Zarra — Fri, 05 Jun 2020 19:52:52 GMT

@rtr13

Unfortunately I didn't fully understand it, but IntervalMatch I think can help you.

Re: Counting customers if they fall within time frame

Brett_Bleess — Wed, 01 Jul 2020 13:04:28 GMT

Just adding a Design Blog link that further expands upon the prior post.

https://community.qlik.com/t5/Qlik-Design-Blog/IntervalMatch/ba-p/1464547

If that was the information you needed, we would greatly appreciate it if you would close out the thread by using the Accept as Solution button on that post to mark it as the solution. This gives the poster credit and lets other Community Members know that worked. If you have further questions, or you did something different, please leave an update post and if that was the solution, use the button on that post...

Regards,
Brett