topic Re: Average in QlikView

topic Re: Average in QlikView https://community.qlik.com/t5/QlikView/Average/m-p/852009#M531139 <HTML><HEAD></HEAD><BODY><P>Dimension: MAR</P><P>Exp: Avg( {<AACTION={'OK', 'CANCEL'}>} Different)</P></BODY></HTML> Tue, 09 Jun 2015 06:43:24 GMT tresB 2015-06-09T06:43:24Z Average https://community.qlik.com/t5/QlikView/Average/m-p/852008#M531138 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>      </P><TABLE border="0" cellpadding="0" cellspacing="0" width="684"><TBODY><TR><TD class="xl63" height="17" width="215">MAR</TD><TD class="xl63" style="border-left: none;" width="98">AACTION</TD><TD class="xl63" style="border-left: none;" width="150">=ALT1</TD><TD class="xl63" style="border-left: none;" width="123">=ACT1</TD><TD class="xl63" style="border-left: none;" width="98">=Different</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">150331SCBLAEADBXXX0724513017</TD><TD class="xl64" style="border-top: none; border-left: none;">HOLD</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">3/31/2015 1:40:19 PM</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4/1/2015 4:04:24 AM</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">14:24:05</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">150331SCBLAEADBXXX0724513017</TD><TD class="xl64" style="border-top: none; border-left: none;">CANCEL</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">3/31/2015 1:40:19 PM</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4/1/2015 10:36:57 AM</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">20:56:38</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">150331SCBLAEADBXXX0724513018</TD><TD>HOLD</TD><TD align="right" class="xl65" style="border-top: none;">3/31/2015 1:30:19 PM</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4/1/2015 4:04:24 AM</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">14:34:05</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">150331SCBLAEADBXXX0724513018</TD><TD>OK</TD><TD align="right" class="xl65" style="border-top: none;">3/31/2015 1:41:19 PM</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4/1/2015 10:36:57 AM</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">20:55:38</TD></TR></TBODY></TABLE><P>Graph should display the Average Different for the MAR Number with the AACTION as OK, CANCEL only</P><P></P><P>Average should be 20:56</P><P></P><P></P><P>Thanks</P></BODY></HTML> Tue, 09 Jun 2015 06:37:21 GMT https://community.qlik.com/t5/QlikView/Average/m-p/852008#M531138 2015-06-09T06:37:21Z Re: Average https://community.qlik.com/t5/QlikView/Average/m-p/852009#M531139 <HTML><HEAD></HEAD><BODY><P>Dimension: MAR</P><P>Exp: Avg( {<AACTION={'OK', 'CANCEL'}>} Different)</P></BODY></HTML> Tue, 09 Jun 2015 06:43:24 GMT https://community.qlik.com/t5/QlikView/Average/m-p/852009#M531139 tresB 2015-06-09T06:43:24Z