Discussion Board for collaboration on QlikView Scripting.
i have a structure like this:
and i would to load this structure in somethings like this:
where entry is the min and the exit is the max of each day and time is the difference in h:mm:ss.
Can someone help me?
Go to Solution.
Here you go:
Load * Inline [
Date(Date#(Date,'DD/MM/YYYY'),'DD/MM/YYYY') as Date,
Time(Min(Time),'hh:mm:ss') as StartTime,
Time(Max(Time),'hh:mm:ss') as EndTime,
Interval(Max(Time)-Min(Time),'hh:mm:ss') as TimeDiff
group by Date;
Drop table T1;
Great!! It work very fine!
Now i'm complicating the structure becouse i would subtrac the time of lunch that is in the middle of the date: 13:45 to 14:42.
I'm trying, but this is my first app in qlickview...