Discussion Board for collaboration related to QlikView Expressor.
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.
Go to Solution.
script in the attachment
Is it possible to share a sample?
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 .
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
I guess I don't have to do it anymore, since Massimo already add a sample
yes, but thank you anyway