Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
PreranaM
New Contributor

IntervalMatch on multiple fields with multiple condition in a table

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.

 

 

2 Replies
kishorj1982
Contributor II

Re: IntervalMatch on multiple fields with multiple condition in a table

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

PreranaM
New Contributor

Re: IntervalMatch on multiple fields with multiple condition in a table

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