Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.