topic Search in date interval in QlikView

Search in date interval

Thu, 22 Dec 2011 14:21:03 GMT

If I can´t do an IntervalMatch, can I choose a day in my calender and find the day in my interval in a another way?

Thu, 22 Dec 2011 15:55:58 GMT

if you use that formula as an expression within a pivot chart (Dimension is ID)

if(Start<=ONLY(CalendarDate) AND Slut >=ONLY(CalendarDate), Start, NULL())

you will get all Start fields which within Start and Slut.

Be aware, only one date must be selected!

Best regards

Michael

Miguel_Angel_Baeyens — Thu, 22 Dec 2011 15:57:44 GMT

Hi Viktoria,

Download and check this application on how to use a calendar with variables (storing from and to dates) and how to use them in set analysis.

Hope that helps.

Miguel

Fri, 23 Dec 2011 08:45:38 GMT

Thanks for the help!