topic How can i do this on column C in QlikView https://community.qlik.com/t5/QlikView/How-can-i-do-this-on-column-C/m-p/26352#M4393 <HTML><HEAD></HEAD><BODY><P><IMG alt="Snap1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/203782_Snap1.png" style="height: 238px; width: 620px;" /></P></BODY></HTML> Tue, 29 May 2018 12:45:13 GMT sadrisalihu 2018-05-29T12:45:13Z How can i do this on column C https://community.qlik.com/t5/QlikView/How-can-i-do-this-on-column-C/m-p/26352#M4393 <HTML><HEAD></HEAD><BODY><P><IMG alt="Snap1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/203782_Snap1.png" style="height: 238px; width: 620px;" /></P></BODY></HTML> Tue, 29 May 2018 12:45:13 GMT https://community.qlik.com/t5/QlikView/How-can-i-do-this-on-column-C/m-p/26352#M4393 sadrisalihu 2018-05-29T12:45:13Z Re: How can i do this on column C https://community.qlik.com/t5/QlikView/How-can-i-do-this-on-column-C/m-p/26353#M4394 <HTML><HEAD></HEAD><BODY><P>May be this</P><P><STRONG>Count(TOTAL &lt;Location&gt; dokumenti)</STRONG></P><P></P><P>or this</P><P><STRONG>Aggr(NODISTINCT Count(dokumenti), Location)</STRONG></P></BODY></HTML> Tue, 29 May 2018 12:47:54 GMT https://community.qlik.com/t5/QlikView/How-can-i-do-this-on-column-C/m-p/26353#M4394 sunny_talwar 2018-05-29T12:47:54Z Re: How can i do this on column C https://community.qlik.com/t5/QlikView/How-can-i-do-this-on-column-C/m-p/26354#M4395 <HTML><HEAD></HEAD><BODY><P>Perhaps like this: sum(total &lt;Location&gt; aggr(count dokumenti),Location,Category))</P></BODY></HTML> Tue, 29 May 2018 12:59:41 GMT https://community.qlik.com/t5/QlikView/How-can-i-do-this-on-column-C/m-p/26354#M4395 Gysbert_Wassenaar 2018-05-29T12:59:41Z Re: How can i do this on column C https://community.qlik.com/t5/QlikView/How-can-i-do-this-on-column-C/m-p/26355#M4396 <HTML><HEAD></HEAD><BODY><P>Thank you very much, Sunny Talwar.</P><P></P><P>You are great man</P></BODY></HTML> Tue, 29 May 2018 13:05:07 GMT https://community.qlik.com/t5/QlikView/How-can-i-do-this-on-column-C/m-p/26355#M4396 sadrisalihu 2018-05-29T13:05:07Z