Hi All,
I have following two tables;
scheduledIntervals:
Load starttime,
endtime,
*
From .............;
currentIntervals:
Load currentStartTime,
currentEndTime,
*
From .....................
What I need to do is to filter the current intervals which have conflicts with scheduled Intervals i.e I need to compare
each value from currentIntervals table (currentStartTime, currentEndTime) with all the values from scheduledIntervals.
Can you please tell how we can achieve it in qlikview? I tried to search many available articles but none of them helped.
I would really appreciate any quick help on it.
Thanks.
