topic Re: How to sum or count with aggr in QlikView https://community.qlik.com/t5/QlikView/How-to-sum-or-count-with-aggr/m-p/1068717#M924021 <HTML><HEAD></HEAD><BODY><P>I am glad I was able to help <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 21 Apr 2016 15:06:29 GMT sunny_talwar 2016-04-21T15:06:29Z How to sum or count with aggr https://community.qlik.com/t5/QlikView/How-to-sum-or-count-with-aggr/m-p/1068712#M924011 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a dataset as below. I calculate the total with this expressions, count(flag). And the Grant Total is the count of flag just for Date, Column1 and Column2. I guess I need to use aggr but I have no idea how to write the expression for Grant Total field. Would you please give me the expression or suggestion on how to achieve it? </P><P></P><P><IMG alt="Sample.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/122182_Sample.png" style="height: auto;" /></P><P></P><P><SPAN style="font-size: 13.3333px;">Thank you for your help!</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-sum-or-count-with-aggr/m-p/1068712#M924011 2020-11-25T16:16:04Z Re: How to sum or count with aggr https://community.qlik.com/t5/QlikView/How-to-sum-or-count-with-aggr/m-p/1068713#M924013 <HTML><HEAD></HEAD><BODY><P>Try this for Grand Total:</P><P></P><P><STRONG>Count(TOTAL &lt;Date, Column1, Column2&gt; flag)</STRONG></P></BODY></HTML> Wed, 20 Apr 2016 15:26:02 GMT https://community.qlik.com/t5/QlikView/How-to-sum-or-count-with-aggr/m-p/1068713#M924013 sunny_talwar 2016-04-20T15:26:02Z Re: How to sum or count with aggr https://community.qlik.com/t5/QlikView/How-to-sum-or-count-with-aggr/m-p/1068714#M924015 <HTML><HEAD></HEAD><BODY><P>count(total &lt;Date,Column1,Column2&gt; flag)</P><P></P><P>The "total" tells it to ignore all dimensions, but the fields between the &lt;&gt; tell it <EM>not</EM> to ignore those specific dimensions.</P></BODY></HTML> Wed, 20 Apr 2016 15:26:31 GMT https://community.qlik.com/t5/QlikView/How-to-sum-or-count-with-aggr/m-p/1068714#M924015 Nicole-Smith 2016-04-20T15:26:31Z Re: How to sum or count with aggr https://community.qlik.com/t5/QlikView/How-to-sum-or-count-with-aggr/m-p/1068715#M924017 <HTML><HEAD></HEAD><BODY><P>Hi Nicole,</P><P></P><P>It's exactly what I need. And I marked your answer as correct because you have a very easy understand explanation. Thank you very much!</P></BODY></HTML> Thu, 21 Apr 2016 14:00:18 GMT https://community.qlik.com/t5/QlikView/How-to-sum-or-count-with-aggr/m-p/1068715#M924017 2016-04-21T14:00:18Z Re: How to sum or count with aggr https://community.qlik.com/t5/QlikView/How-to-sum-or-count-with-aggr/m-p/1068716#M924019 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny for your answer!!</P></BODY></HTML> Thu, 21 Apr 2016 14:00:44 GMT https://community.qlik.com/t5/QlikView/How-to-sum-or-count-with-aggr/m-p/1068716#M924019 2016-04-21T14:00:44Z Re: How to sum or count with aggr https://community.qlik.com/t5/QlikView/How-to-sum-or-count-with-aggr/m-p/1068717#M924021 <HTML><HEAD></HEAD><BODY><P>I am glad I was able to help <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 21 Apr 2016 15:06:29 GMT https://community.qlik.com/t5/QlikView/How-to-sum-or-count-with-aggr/m-p/1068717#M924021 sunny_talwar 2016-04-21T15:06:29Z