https://community.qlik.com/t5/Water-Cooler/Using-2-aggregate-functions/m-p/1513324#M7082 <P>Hi</P><P>I want to count cities having sum(Quantity)&gt;1000 and sum(Sales)&gt;1200 for the maximum month year in Date( In sample Data :- Sept. 2018)</P><P>Sample Data:</P><TABLE><TBODY><TR><TD>City</TD><TD>Quantity</TD><TD>Sales(Rs)</TD><TD>Date</TD></TR><TR><TD>C1</TD><TD>1000</TD><TD>2000</TD><TD>12-Sep-18</TD></TR><TR><TD>C2</TD><TD>12312</TD><TD>12310</TD><TD>13-Sep-18</TD></TR><TR><TD>C3</TD><TD>121</TD><TD>21223</TD><TD>12-May-18</TD></TR><TR><TD>C4</TD><TD>1212</TD><TD>1313</TD><TD>30-Aug-17</TD></TR><TR><TD>C1</TD><TD>1212</TD><TD>12123</TD><TD>20-Sep-18</TD></TR><TR><TD>C2</TD><TD>121</TD><TD>1313</TD><TD>08-Nov-18</TD></TR><TR><TD>C3</TD><TD>121</TD><TD>132</TD><TD>09-Nov-17</TD></TR></TBODY></TABLE> Wed, 28 Nov 2018 06:35:33 GMT harveenkaur 2018-11-28T06:35:33Z https://community.qlik.com/t5/Water-Cooler/Using-2-aggregate-functions/m-p/1513324#M7082 <P>Hi</P><P>I want to count cities having sum(Quantity)&gt;1000 and sum(Sales)&gt;1200 for the maximum month year in Date( In sample Data :- Sept. 2018)</P><P>Sample Data:</P><TABLE><TBODY><TR><TD>City</TD><TD>Quantity</TD><TD>Sales(Rs)</TD><TD>Date</TD></TR><TR><TD>C1</TD><TD>1000</TD><TD>2000</TD><TD>12-Sep-18</TD></TR><TR><TD>C2</TD><TD>12312</TD><TD>12310</TD><TD>13-Sep-18</TD></TR><TR><TD>C3</TD><TD>121</TD><TD>21223</TD><TD>12-May-18</TD></TR><TR><TD>C4</TD><TD>1212</TD><TD>1313</TD><TD>30-Aug-17</TD></TR><TR><TD>C1</TD><TD>1212</TD><TD>12123</TD><TD>20-Sep-18</TD></TR><TR><TD>C2</TD><TD>121</TD><TD>1313</TD><TD>08-Nov-18</TD></TR><TR><TD>C3</TD><TD>121</TD><TD>132</TD><TD>09-Nov-17</TD></TR></TBODY></TABLE> Wed, 28 Nov 2018 06:35:33 GMT https://community.qlik.com/t5/Water-Cooler/Using-2-aggregate-functions/m-p/1513324#M7082 harveenkaur 2018-11-28T06:35:33Z