topic Re: Calculating the Detect stop in QlikView

topic Re: Calculating the Detect stop in QlikView https://community.qlik.com/t5/QlikView/Calculating-the-Detect-stop/m-p/1138803#M910731 <HTML><HEAD></HEAD><BODY><P>Chart: Straight Table</P><P>Dimension: Pick(Match(MachineNumber, 1,2), 'Lower Arm', 'Housing')</P><P>Exp: Count( {<Program={'DETECT STOP'}>} Program)</P><P></P><P></P><P>The dimension could be dynamic if you maintain a MachineNumber-Program mapping.</P></BODY></HTML> Tue, 07 Jun 2016 07:30:19 GMT tresB 2016-06-07T07:30:19Z Calculating the Detect stop https://community.qlik.com/t5/QlikView/Calculating-the-Detect-stop/m-p/1138802#M910730 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I want to calculate how many DETECT STOP occured during production of Lower Arm and for  Housing.</P><P>Expecte output:</P><P>For Lower Arm : 1 <SPAN style="font-size: 13.3333px;"> DETECT STOP</SPAN></P><P><SPAN style="font-size: 13.3333px;">For Housing      : 5 <SPAN style="font-size: 13.3333px;">DETECT STOP</SPAN></SPAN></P><P></P><P></P><P></P><P></P><P>        </P><P></P><P>        </P><TABLE border="0" cellpadding="0" cellspacing="0" width="604"><TBODY><TR><TD height="20" width="112">MachineNumber</TD><TD width="82">Start</TD><TD width="67">Stop</TD><TD width="87">Program</TD><TD width="108">CoolantPumped</TD><TD width="84">RPM</TD><TD width="64">OpID</TD></TR><TR><TD align="right" height="20">1</TD><TD align="right" class="xl63">07:30</TD><TD align="right" class="xl63">08:00</TD><TD>Lower Arm</TD><TD align="right">22</TD><TD align="right">2000</TD><TD align="right">4</TD></TR><TR><TD align="right" height="20">1</TD><TD align="right" class="xl63">08:10</TD><TD align="right" class="xl63">08:50</TD><TD>Lower Arm</TD><TD align="right">47</TD><TD align="right">8000</TD><TD align="right">4</TD></TR><TR><TD align="right" height="20">1</TD><TD align="right" class="xl63">08:30</TD><TD align="right" class="xl63">08:40</TD><TD>DETECT STOP</TD><TD align="right">0</TD><TD align="right">0</TD><TD align="right">4</TD></TR><TR><TD align="right" height="20">1</TD><TD align="right" class="xl63">09:15</TD><TD align="right" class="xl63">09:40</TD><TD>Lower Arm</TD><TD align="right">24</TD><TD align="right">2200</TD><TD align="right">4</TD></TR><TR><TD align="right" height="20">1</TD><TD align="right" class="xl63">09:47</TD><TD align="right" class="xl63">10:23</TD><TD>Lower Arm</TD><TD align="right">22</TD><TD align="right">2000</TD><TD align="right">4</TD></TR><TR><TD align="right" height="20">1</TD><TD align="right" class="xl63">10:35</TD><TD align="right" class="xl63">11:05</TD><TD>Lower Arm</TD><TD align="right">27</TD><TD align="right">2300</TD><TD align="right">4</TD></TR><TR><TD align="right" height="20">1</TD><TD align="right" class="xl63">11:22</TD><TD align="right" class="xl63">11:52</TD><TD>Lower Arm</TD><TD align="right">23</TD><TD align="right">2000</TD><TD align="right">4</TD></TR><TR><TD align="right" height="20">1</TD><TD align="right" class="xl63">13:05</TD><TD align="right" class="xl63">13:33</TD><TD>Lower Arm</TD><TD align="right">23</TD><TD align="right">2000</TD><TD align="right">4</TD></TR><TR><TD align="right" height="20">1</TD><TD align="right" class="xl63">13:41</TD><TD align="right" class="xl63">14:05</TD><TD>Lower Arm</TD><TD align="right">23</TD><TD align="right">2000</TD><TD align="right">4</TD></TR><TR><TD align="right" height="20">1</TD><TD align="right" class="xl63">14:15</TD><TD align="right" class="xl63">14:38</TD><TD>Lower Arm</TD><TD align="right">30</TD><TD align="right">3500</TD><TD align="right">4</TD></TR><TR><TD align="right" height="20">1</TD><TD align="right" class="xl63">15:40</TD><TD align="right" class="xl63">16:08</TD><TD>Lower Arm</TD><TD align="right">23</TD><TD align="right">2000</TD><TD align="right">4</TD></TR><TR><TD align="right" height="20">1</TD><TD align="right" class="xl63">16:15</TD><TD align="right" class="xl63">16:45</TD><TD>Lower Arm</TD><TD align="right">23</TD><TD align="right">2000</TD><TD align="right">4</TD></TR><TR><TD align="right" height="20">2</TD><TD align="right" class="xl63">07:05</TD><TD align="right" class="xl63">07:10</TD><TD>Housing</TD><TD align="right">5</TD><TD align="right">9717</TD><TD align="right">3</TD></TR><TR><TD align="right" height="20">2</TD><TD align="right" class="xl63">07:11</TD><TD align="right" class="xl63">07:13</TD><TD>Housing</TD><TD align="right">5</TD><TD align="right">10398</TD><TD align="right">3</TD></TR><TR><TD align="right" height="20">2</TD><TD align="right" class="xl63">07:16</TD><TD align="right" class="xl63">07:21</TD><TD>Housing</TD><TD align="right">5</TD><TD align="right">9988</TD><TD align="right">3</TD></TR><TR><TD align="right" height="20">2</TD><TD align="right" class="xl63">07:27</TD><TD align="right" class="xl63">07:30</TD><TD>Housing</TD><TD align="right">5</TD><TD align="right">10900</TD><TD align="right">3</TD></TR><TR><TD align="right" height="20">2</TD><TD align="right" class="xl63">07:38</TD><TD align="right" class="xl63">07:42</TD><TD>Housing</TD><TD align="right">5</TD><TD align="right">10184</TD><TD align="right">3</TD></TR><TR><TD align="right" height="20">2</TD><TD align="right" class="xl63">07:49</TD><TD align="right" class="xl63">07:54</TD><TD>Housing</TD><TD align="right">5</TD><TD align="right">9925</TD><TD align="right">3</TD></TR><TR><TD align="right" height="20">2</TD><TD align="right" class="xl63">08:00</TD><TD align="right" class="xl63">08:03</TD><TD>Housing</TD><TD align="right">5</TD><TD align="right">10533</TD><TD align="right">3</TD></TR><TR><TD align="right" height="20">2</TD><TD align="right" class="xl63">08:11</TD><TD align="right" class="xl63">08:13</TD><TD>Housing</TD><TD align="right">5</TD><TD align="right">10731</TD><TD align="right">3</TD></TR><TR><TD align="right" height="20">2</TD><TD align="right" class="xl63">08:22</TD><TD align="right" class="xl63">08:24</TD><TD>Housing</TD><TD align="right">5</TD><TD align="right">10862</TD><TD align="right">3</TD></TR><TR><TD align="right" height="20">2</TD><TD align="right" class="xl63">08:33</TD><TD align="right" class="xl63">08:35</TD><TD>Housing</TD><TD align="right">5</TD><TD align="right">10859</TD><TD align="right">3</TD></TR><TR><TD align="right" height="20">2</TD><TD align="right" class="xl63">08:44</TD><TD align="right" class="xl63">08:49</TD><TD>Housing</TD><TD align="right">5</TD><TD align="right">9018</TD><TD align="right">3</TD></TR><TR><TD align="right" height="20">2</TD><TD align="right" class="xl63">08:55</TD><TD align="right" class="xl63">09:00</TD><TD>DETECT STOP</TD><TD align="right">0</TD><TD align="right">0</TD><TD align="right">3</TD></TR><TR><TD align="right" height="20">2</TD><TD align="right" class="xl63">09:06</TD><TD align="right" class="xl63">09:17</TD><TD>Housing</TD><TD align="right">5</TD><TD align="right">9171</TD><TD align="right">3</TD></TR><TR><TD align="right" height="20">2</TD><TD align="right" class="xl63">09:17</TD><TD align="right" class="xl63">09:22</TD><TD>DETECT STOP</TD><TD align="right">0</TD><TD align="right">0</TD><TD align="right">3</TD></TR><TR><TD align="right" height="20">2</TD><TD align="right" class="xl63">09:28</TD><TD align="right" class="xl63">09:33</TD><TD>Housing</TD><TD align="right">5</TD><TD align="right">9278</TD><TD align="right">3</TD></TR><TR><TD align="right" height="20">2</TD><TD align="right" class="xl63">09:39</TD><TD align="right" class="xl63">09:44</TD><TD>DETECT STOP</TD><TD align="right">0</TD><TD align="right">0</TD><TD align="right">3</TD></TR><TR><TD align="right" height="20">2</TD><TD align="right" class="xl63">09:50</TD><TD align="right" class="xl63">09:55</TD><TD>Housing</TD><TD align="right">5</TD><TD align="right">9855</TD><TD align="right">3</TD></TR><TR><TD align="right" height="20">2</TD><TD align="right" class="xl63">10:01</TD><TD align="right" class="xl63">10:06</TD><TD>DETECT STOP</TD><TD align="right">0</TD><TD align="right">0</TD><TD align="right">3</TD></TR><TR><TD align="right" height="20">2</TD><TD align="right" class="xl63">10:12</TD><TD align="right" class="xl63">10:17</TD><TD>Housing</TD><TD align="right">5</TD><TD align="right">9567</TD><TD align="right">3</TD></TR><TR><TD align="right" height="20">2</TD><TD align="right" class="xl63">10:23</TD><TD align="right" class="xl63">10:28</TD><TD>Housing</TD><TD align="right">5</TD><TD align="right">9511</TD><TD align="right">3</TD></TR><TR><TD align="right" height="20">2</TD><TD align="right" class="xl63">10:34</TD><TD align="right" class="xl63">10:39</TD><TD>Housing</TD><TD align="right">5</TD><TD align="right">9781</TD><TD align="right">3</TD></TR><TR><TD align="right" height="20">2</TD><TD align="right" class="xl63">10:45</TD><TD align="right" class="xl63">10:50</TD><TD>Housing</TD><TD align="right">5</TD><TD align="right">9999</TD><TD align="right">3</TD></TR><TR><TD align="right" height="20">2</TD><TD align="right" class="xl63">10:56</TD><TD align="right" class="xl63">11:01</TD><TD>Housing</TD><TD align="right">5</TD><TD align="right">9538</TD><TD align="right">3</TD></TR><TR><TD align="right" height="20">2</TD><TD align="right" class="xl63">11:07</TD><TD align="right" class="xl63">11:09</TD><TD>Housing</TD><TD align="right">5</TD><TD align="right">10990</TD><TD align="right">3</TD></TR><TR><TD align="right" height="20">2</TD><TD align="right" class="xl63">11:18</TD><TD align="right" class="xl63">11:23</TD><TD>Housing</TD><TD align="right">5</TD><TD align="right">9274</TD><TD align="right">3</TD></TR><TR><TD align="right" height="20">2</TD><TD align="right" class="xl63">11:29</TD><TD align="right" class="xl63">11:34</TD><TD>DETECT STOP</TD><TD align="right">0</TD><TD align="right">0</TD><TD align="right">3</TD></TR><TR><TD align="right" height="20">2</TD><TD align="right" class="xl63">11:40</TD><TD align="right" class="xl63">11:43</TD><TD>Housing</TD><TD align="right">5</TD><TD align="right">10313</TD><TD align="right">3</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Calculating-the-Detect-stop/m-p/1138802#M910730 ajsjoshua 2020-11-25T16:16:04Z Re: Calculating the Detect stop https://community.qlik.com/t5/QlikView/Calculating-the-Detect-stop/m-p/1138803#M910731 <HTML><HEAD></HEAD><BODY><P>Chart: Straight Table</P><P>Dimension: Pick(Match(MachineNumber, 1,2), 'Lower Arm', 'Housing')</P><P>Exp: Count( {<Program={'DETECT STOP'}>} Program)</P><P></P><P></P><P>The dimension could be dynamic if you maintain a MachineNumber-Program mapping.</P></BODY></HTML> Tue, 07 Jun 2016 07:30:19 GMT https://community.qlik.com/t5/QlikView/Calculating-the-Detect-stop/m-p/1138803#M910731 tresB 2016-06-07T07:30:19Z Re: Calculating the Detect stop https://community.qlik.com/t5/QlikView/Calculating-the-Detect-stop/m-p/1138804#M910732 <HTML><HEAD></HEAD><BODY><P>Dear  <A href="https://community.qlik.com/people/tresesco">tresesco</A></P><P></P><P></P><P>Thank u very much.</P></BODY></HTML> Tue, 07 Jun 2016 07:37:49 GMT https://community.qlik.com/t5/QlikView/Calculating-the-Detect-stop/m-p/1138804#M910732 ajsjoshua 2016-06-07T07:37:49Z