Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I'm trying to achieve similar results in Qlikview script as you'd get from a correlated subquery in any database. I have a dataset as below;
ComponentName Action ActionDate
Comp-A START 26-Feb-2013 10:30:00
Comp-B START 26-Feb-2013 10:50:00
Comp-A STOP 26-Feb-2013 12:40:00
Comp-A START 26-Feb-2013 14:30:00
Comp-A STOP 26-Feb-2013 19:30:00
Comp-B STOP 26-Feb-2013 19:30:00
Comp-C START 26-Feb-2013 21:50:00
Comp-C STOP 26-Feb-2013 22:30:00
From the above data, I wish to analyse what component was running at any given time. For example,
at 12:00 - A, B
at 14:00 - B
at 16:00 - A, B
at 20:00 - None
at 22:00 - C
This is easily done in database using subquery but can this be done using qlikview script as well? I need to do this for every hour of the day for a much larger set of data.
Any guidance to achive such a result is much appreciated.
Regards
Vikas
Hi Vikas,
It sounds like you could use IntervalMatch to accomplish this.
Hi Vikas,
It sounds like you could use IntervalMatch to accomplish this.
Thanks Johannes
IntervalMatch did solve my problem. I just had to create intervals in one record i.e. merge sets of records into one to get start/end time in one row which I did in database itself.
Appreciate your help.
Vikas