Discussion board where members can get started with QlikView.
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
FromDate <= CMFrom and
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 :
<=TempMaxDate (can set it to 2020 something)
<= CMFrom and
>=TempMinDate (can set it to 1900 something)
<= LCMTo and
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.