Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In the fact table I have 4 Date : CMFrom,CMTo,LCMFrom,LCMTo.
and In Date Range have 2 Date : FromDate, ToDate
i have multiple condition :
ToDate >=LCMFrom and
<=CMTo and
>=CMFrom
FromDate <= CMFrom and
<= LCMTo
can you please suggest something about this.
i am thinking to create 2 more date field in fact table just to create interval(TempMaxDate & TempMinDate) :
Inteval1 : ToDate :
>=LCMFrom and
<=CMTo
Interval2 :ToDate:
>=CMFrom and
<=TempMaxDate (can set it to 2020 something)
Interval3 :FromDate:
<= CMFrom and
>=TempMinDate (can set it to 1900 something)
Interval4 :FromDate:
<= LCMTo and
>=TempMinDate (can set it to 1900 something)
till now i have implemented 2 intervals and its taking so much time to reload , i dnt know what will happen if i add 4 interval.
This requirement is like Extended interval match feature as there are multiple key fields.
https://community.qlik.com/t5/New-to-QlikView/Extended-Interval-Match/td-p/711937
Thanks