topic Re: start and stop time in QlikView

start and stop time

ajsjoshua — Mon, 06 Jun 2016 09:26:15 GMT

Hi,

I want to calculate the Count of each part produced by hour of the day.

PFA

Anonymous — Mon, 06 Jun 2016 10:18:29 GMT

Is it like this ?

Pulkit_Thukral — Mon, 06 Jun 2016 10:38:33 GMT

Hi Joshua,

Does the below graph fulfills your requirement ?

I have created a custom field "Hour" in scripting to achieve this .

Script :

LOAD MachineNumber,

Start,

Stop,

Program,

CoolantPumped,

RPM,

OpID,

HOUR( DATE(Start,'h:mm:ss TT')) as Hour

FROM

HaasMachines.xlsx

(ooxml, embedded labels, table is Sheet1);

ajsjoshua — Mon, 06 Jun 2016 10:44:49 GMT

Hi Pulikit,

It should be based on the hour of the day.

Ex: if time is 5pm how much program completed lik that i want to show

Pulkit_Thukral — Mon, 06 Jun 2016 11:34:38 GMT

First Question :-Hour of the day will be based on Start or Stop Time.

Second Question :- condition for program completed ?