Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Calculating the Detect stop

Hi all,

I want to calculate how many DETECT STOP occured during production of Lower Arm and for  Housing.

Expecte output:

For Lower Arm : 1 DETECT STOP

For Housing      : 5 DETECT STOP

       

       

MachineNumberStartStopProgramCoolantPumpedRPMOpID
107:3008:00Lower Arm2220004
108:1008:50Lower Arm4780004
108:3008:40DETECT STOP004
109:1509:40Lower Arm2422004
109:4710:23Lower Arm2220004
110:3511:05Lower Arm2723004
111:2211:52Lower Arm2320004
113:0513:33Lower Arm2320004
113:4114:05Lower Arm2320004
114:1514:38Lower Arm3035004
115:4016:08Lower Arm2320004
116:1516:45Lower Arm2320004
207:0507:10Housing597173
207:1107:13Housing5103983
207:1607:21Housing599883
207:2707:30Housing5109003
207:3807:42Housing5101843
207:4907:54Housing599253
208:0008:03Housing5105333
208:1108:13Housing5107313
208:2208:24Housing5108623
208:3308:35Housing5108593
208:4408:49Housing590183
208:5509:00DETECT STOP003
209:0609:17Housing591713
209:1709:22DETECT STOP003
209:2809:33Housing592783
209:3909:44DETECT STOP003
209:5009:55Housing598553
210:0110:06DETECT STOP003
210:1210:17Housing595673
210:2310:28Housing595113
210:3410:39Housing597813
210:4510:50Housing599993
210:5611:01Housing595383
211:0711:09Housing5109903
211:1811:23Housing592743
211:2911:34DETECT STOP003
211:4011:43Housing5103133
1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Chart: Straight Table

Dimension: Pick(Match(MachineNumber, 1,2), 'Lower Arm', 'Housing')

Exp: Count( {<Program={'DETECT STOP'}>} Program)

The dimension could be dynamic if you maintain a MachineNumber-Program mapping.

View solution in original post

2 Replies
Highlighted
MVP
MVP

Chart: Straight Table

Dimension: Pick(Match(MachineNumber, 1,2), 'Lower Arm', 'Housing')

Exp: Count( {<Program={'DETECT STOP'}>} Program)

The dimension could be dynamic if you maintain a MachineNumber-Program mapping.

View solution in original post

Highlighted
Specialist
Specialist

Dear  tresesco

Thank u very much.