Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
ajsjoshua
Contributor III

start and stop time

Hi,

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

PFA

1 Solution

Accepted Solutions
pulkit1611
Contributor II

Re: start and stop time

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);

Capture.PNG

4 Replies
galax_allu
Valued Contributor

Re: start and stop time

Hi

Is it like this ?

MachineNumber Machines produced by hours
105:34:00
204:36:00
303:34:00
407:46:00
508:06:00
608:09:00
708:52:00
pulkit1611
Contributor II

Re: start and stop time

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);

Capture.PNG

ajsjoshua
Contributor III

Re: start and stop time

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

pulkit1611
Contributor II

Re: start and stop time

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

Second Question :- condition for program completed ?

Community Browser