Discussion board where members can get started with QlikView.
I need so urgent calculate the quantity the tickets are into the 3 diferents range/shifts and i have to calculate the average of hours. The following is my data source:
EXPECTED VALUE 1 (I need plot in bar chart 😞
AXIS X AXIS Y
EXPECTED VALUE 2 (Only show the duration):
Thanks for response that, really im scared!
LOAD [TASK ID],
Interval(FINISHED - CREATED, 'hh:mm:ss') as Duration
(html, codepage is 1252, embedded labels, table is @1);
Avg Duration Expression:
Here is the other requirement as well:
'Shift' & If(Time(Frac(CREATED)) > MakeTime(22) or Time(Frac(CREATED)) <= MakeTime(6), 1,
If(Time(Frac(CREATED)) > MakeTime(14), 2,
If(Time(Frac(CREATED)) > MakeTime(6), 3))) as Shift,