Qlik Community

QlikView Expressor

Discussion Board for collaboration related to QlikView Expressor.

Not applicable

Check if date is between two other

Hi everyone,

First, sorry for my bad english, hope you will be able to understand what I mean.

I have some data and especially some date. I would like to have as dimension the time, from the early date (day by day) and count item when the date is between  the start date and the end date.

Something like :

count (Distinct If(item_date_start <= date_dimension <= item_date_end, 1, 0 )

Actually, my dimension is the item_date_start.

Thank You

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Check if date is between two other

script in the attachment

1.png

6 Replies
MVP
MVP

Re: Check if date is between two other

Is it possible to share a sample?

Not applicable

Re: Check if date is between two other

hi

example :

event- start_date - end_date

A - 01/205 - 03/2015

B - 02/2005 - 06/2015

C - 01/2015 - 08/2015

January : 2 events

February : 3 events

March : 3 events

April : 2 events ..

The easiest way i found was to take the start date as dimension .

MVP
MVP

Re: Check if date is between two other

I think you need to use interval match function here. Let me work on a sample, in the mean time you can look here: IntervalMatch

Highlighted
MVP
MVP

Re: Check if date is between two other

script in the attachment

1.png

MVP
MVP

Re: Check if date is between two other

I guess I don't have to do it anymore, since Massimo‌ already add a sample

Not applicable

Re: Check if date is between two other

yes, but thank you anyway