topic IntervalMatch on multiple fields with multiple condition in a table in QlikView

IntervalMatch on multiple fields with multiple condition in a table

Anonymous — Sat, 16 Nov 2024 05:09:11 GMT

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.

kishorj1982 — Fri, 23 Nov 2018 10:16:43 GMT

This requirement is like Extended interval match feature as there are multiple key fields.

Thanks

Anonymous — Mon, 26 Nov 2018 01:36:24 GMT

Thanks Kishor for replying , but still not clear with what i need to do