If the date point is between two dates

[OWSLA]

Hi. I’m new to Qlik and I am dealing with HR data modeling.
In the case of a single personnel appointment, There are starting dates and end dates as START_YMD and END_YMD.

I am trying to distinguish if a designated date point is between START_YMD and END_YMD. (Given that dates from minimum to maximum dates are generated by the master calendar)

The way I tried is that I generated incrementing dates starting from START_YMD to END_YMD as shown below.

However, I wonder if there are other ways done without making dummy dates.

Is there anyone who dealt with a similar case? Any recommendations are appreciated.

[Oleg_Troyansky]

Hi there,

Welcome to the Qlik community! 

Issues of this kind are usually solved in the data model using an INTERVALMATCH load - look it up in the documentation. I have a very detailed description of this technique in my book, if you'd like to check it out.

[anat]

Use Intervalmatch function to get the values between start and end date.

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptP...