Discussion Board for collaboration on QlikView Scripting.
There is In and Out and Start and End... How are we interval-matching them?
I believe an IF statement would work in your situation
If(In>=Start and Out <= Stop,'X') as Flag
Date(Date,'DD/MM/YYYY') as Date,
Time(In,'hh:mm') as In ,
Time(Out,'hh:mm') as Out;
LOAD * INLINE
Time(Start,'hh:mm') as Start ,
Time(Stop,'hh:mm') as Stop;
Drop Table Table;
This does exactly what I asked, however I now realize I should rephrase the question as I need to see the number of minutes that occurred not the count of cases...thank you for helping
Rephrased the question...thanks