topic count Dimension in QlikView https://community.qlik.com/t5/QlikView/count-Dimension/m-p/1119488#M463970 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>How can count number of string , for example , how can i count the number of countries in the list below </P><P></P><P><IMG alt="count.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/125354_count.PNG" style="height: auto;" /></P></BODY></HTML> Sun, 22 May 2016 14:35:57 GMT 2016-05-22T14:35:57Z count Dimension https://community.qlik.com/t5/QlikView/count-Dimension/m-p/1119488#M463970 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>How can count number of string , for example , how can i count the number of countries in the list below </P><P></P><P><IMG alt="count.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/125354_count.PNG" style="height: auto;" /></P></BODY></HTML> Sun, 22 May 2016 14:35:57 GMT https://community.qlik.com/t5/QlikView/count-Dimension/m-p/1119488#M463970 2016-05-22T14:35:57Z Re: count Dimension https://community.qlik.com/t5/QlikView/count-Dimension/m-p/1119489#M463971 <HTML><HEAD></HEAD><BODY><P>You can count the distinct field values like</P><P></P><P>=COUNT( <STRONG>DISTINCT</STRONG> COUNTRY_AGG)</P><P></P><P>If you want to count all field records, remove the DISTINCT qualifier from the count.</P><P></P><P>And if you want to count disregarding any user selections:</P><P></P><P><SPAN style="font-size: 13.3333px;">=COUNT({<STRONG>1}</STRONG> DISTINCT COUNTRY_AGG)</SPAN></P></BODY></HTML> Sun, 22 May 2016 21:28:35 GMT https://community.qlik.com/t5/QlikView/count-Dimension/m-p/1119489#M463971 swuehl 2016-05-22T21:28:35Z