topic Re: Counting orders with zero costs weekly in QlikView https://community.qlik.com/t5/QlikView/Counting-orders-with-zero-costs-weekly/m-p/1350868#M460473 <HTML><HEAD></HEAD><BODY><P>try this</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">count({$&lt;System_status={'TECO'},<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">TotCostAct={0}&gt;} Order)</SPAN></SPAN></P></BODY></HTML> Tue, 16 May 2017 13:04:03 GMT Kushal_Chawda 2017-05-16T13:04:03Z Counting orders with zero costs weekly https://community.qlik.com/t5/QlikView/Counting-orders-with-zero-costs-weekly/m-p/1350866#M460471 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I'am new to this site and qlikview.<BR />Bud i have the following question and i hope there is someone on line to help me:</P><P></P><P>I have the following dimentions in qlikview:</P><P>1 Timestamp_loaded (weekly upload orders)</P><P>2 Order</P><P>3 System_status</P><P>4 TotCostAct</P><P>I'am building a dashboard and i want to get the orders that are TECO (=System_status)&nbsp; with zero costs weekly.</P><P>Can any one help me with this?</P><P></P><P>=count({$&lt;System_status=('TECO'</P><P></P><P>gr. Patrick Vos</P></BODY></HTML> Tue, 16 May 2017 07:14:37 GMT https://community.qlik.com/t5/QlikView/Counting-orders-with-zero-costs-weekly/m-p/1350866#M460471 Anonymous 2017-05-16T07:14:37Z Re: Counting orders with zero costs weekly https://community.qlik.com/t5/QlikView/Counting-orders-with-zero-costs-weekly/m-p/1350867#M460472 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/message/1268649">Hi everyone,</A></P></BODY></HTML> Tue, 16 May 2017 12:15:03 GMT https://community.qlik.com/t5/QlikView/Counting-orders-with-zero-costs-weekly/m-p/1350867#M460472 qlikview979 2017-05-16T12:15:03Z Re: Counting orders with zero costs weekly https://community.qlik.com/t5/QlikView/Counting-orders-with-zero-costs-weekly/m-p/1350868#M460473 <HTML><HEAD></HEAD><BODY><P>try this</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">count({$&lt;System_status={'TECO'},<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">TotCostAct={0}&gt;} Order)</SPAN></SPAN></P></BODY></HTML> Tue, 16 May 2017 13:04:03 GMT https://community.qlik.com/t5/QlikView/Counting-orders-with-zero-costs-weekly/m-p/1350868#M460473 Kushal_Chawda 2017-05-16T13:04:03Z