topic Re: Count unique rows in QlikView https://community.qlik.com/t5/QlikView/Count-unique-rows/m-p/1081964#M925339 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>Count(DISTINCT PostingReference)</STRONG></P></BODY></HTML> Fri, 08 Apr 2016 13:16:34 GMT sunny_talwar 2016-04-08T13:16:34Z Count unique rows https://community.qlik.com/t5/QlikView/Count-unique-rows/m-p/1081963#M925338 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P></P><P>I want to create in qlikview&nbsp; a expression which tell me about&nbsp; the total webshop order. In the underneath picture of row R the total row is 17.&nbsp; the correct row is actually 13. which expression should i use to count the unique rows?</P><P></P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/121047_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P>Greets,</P><P></P><P>Rega</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Count-unique-rows/m-p/1081963#M925338 2020-11-25T16:16:04Z Re: Count unique rows https://community.qlik.com/t5/QlikView/Count-unique-rows/m-p/1081964#M925339 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>Count(DISTINCT PostingReference)</STRONG></P></BODY></HTML> Fri, 08 Apr 2016 13:16:34 GMT https://community.qlik.com/t5/QlikView/Count-unique-rows/m-p/1081964#M925339 sunny_talwar 2016-04-08T13:16:34Z Re: Count unique rows https://community.qlik.com/t5/QlikView/Count-unique-rows/m-p/1081965#M925340 <HTML><HEAD></HEAD><BODY><P>try</P><P>=Count(FieldName)&nbsp;&nbsp;&nbsp;&nbsp; ----&gt;&nbsp; it will give total count.</P><P></P><P>=Count(Distinct FiledName)&nbsp; ----- &gt;it will give unique count.</P></BODY></HTML> Fri, 08 Apr 2016 13:50:29 GMT https://community.qlik.com/t5/QlikView/Count-unique-rows/m-p/1081965#M925340 Chanty4u 2016-04-08T13:50:29Z Re: Count unique rows https://community.qlik.com/t5/QlikView/Count-unique-rows/m-p/1081966#M925341 <HTML><HEAD></HEAD><BODY><P>Hi Rega,</P><P></P><P>Try the Distinct function like Sunny has instructed.</P></BODY></HTML> Fri, 08 Apr 2016 13:50:29 GMT https://community.qlik.com/t5/QlikView/Count-unique-rows/m-p/1081966#M925341 2016-04-08T13:50:29Z