topic AW:Calculate available Tills ? in QlikView https://community.qlik.com/t5/QlikView/Calculate-available-Tills/m-p/172530#M42047 <HTML><HEAD></HEAD><BODY><P>Thanks very much for your time and the Example, I was struggling to do it with with set analysis</P><P>Colin R</P><P></P></BODY></HTML> Thu, 03 Dec 2009 00:26:04 GMT 2009-12-03T00:26:04Z Calculate available Tills ? https://community.qlik.com/t5/QlikView/Calculate-available-Tills/m-p/172528#M42045 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a pivot Table containing no of tills at branch and the Sales Value for each active till, I need to know if there are any more tills available at the Branch to take sales. As per the Attached Image.</P><P>So im looking for an expression like BranchTillCount-Count(ActiveTills) Im getting incorrect values for the Count(TillNO) im guessing its counting the underlying values ?</P><P>ColinR</P><P></P><P></P></BODY></HTML> Wed, 02 Dec 2009 21:25:41 GMT https://community.qlik.com/t5/QlikView/Calculate-available-Tills/m-p/172528#M42045 2009-12-02T21:25:41Z AW:Calculate available Tills ? https://community.qlik.com/t5/QlikView/Calculate-available-Tills/m-p/172529#M42046 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>you can use aggr() for it.</P><P>Have a look at attached file.</P><P></P><P>Kind regards.</P></BODY></HTML> Wed, 02 Dec 2009 22:32:18 GMT https://community.qlik.com/t5/QlikView/Calculate-available-Tills/m-p/172529#M42046 2009-12-02T22:32:18Z AW:Calculate available Tills ? https://community.qlik.com/t5/QlikView/Calculate-available-Tills/m-p/172530#M42047 <HTML><HEAD></HEAD><BODY><P>Thanks very much for your time and the Example, I was struggling to do it with with set analysis</P><P>Colin R</P><P></P></BODY></HTML> Thu, 03 Dec 2009 00:26:04 GMT https://community.qlik.com/t5/QlikView/Calculate-available-Tills/m-p/172530#M42047 2009-12-03T00:26:04Z