topic Re: distinct function? in QlikView https://community.qlik.com/t5/QlikView/distinct-function/m-p/738899#M1080249 <HTML><HEAD></HEAD><BODY><P>see this</P><P></P><P>hope helps</P><P></P><P><A href="https://community.qlik.com/thread/76250">What is the use of Distinct?</A></P><P></P><P><A href="https://community.qlik.com/thread/76265">What is the use of Distinct?</A></P></BODY></HTML> Wed, 09 Jul 2014 13:31:25 GMT fkeuroglian 2014-07-09T13:31:25Z distinct function? https://community.qlik.com/t5/QlikView/distinct-function/m-p/738895#M1080241 <HTML><HEAD></HEAD><BODY><P>what is work of&nbsp; distinct&nbsp; function?</P><P></P><P>whether it wont allow duplicate values are ?</P></BODY></HTML> Wed, 09 Jul 2014 12:10:18 GMT https://community.qlik.com/t5/QlikView/distinct-function/m-p/738895#M1080241 2014-07-09T12:10:18Z Re: distinct function? https://community.qlik.com/t5/QlikView/distinct-function/m-p/738896#M1080242 <HTML><HEAD></HEAD><BODY><P>In load or Select or aggregations, Distinct predicate discards duplicate values (of the specified fields)</P></BODY></HTML> Wed, 09 Jul 2014 12:15:43 GMT https://community.qlik.com/t5/QlikView/distinct-function/m-p/738896#M1080242 alexandros17 2014-07-09T12:15:43Z Re: distinct function? https://community.qlik.com/t5/QlikView/distinct-function/m-p/738897#M1080243 <HTML><HEAD></HEAD><BODY><P>Distinct will return the distinct values.</P><P></P><P>For example, if you have a field with three values:</P><P></P><P>Field:</P><P>A</P><P>A</P><P>B</P><P></P><P>count(field) will return 3 because you have 3 values in field</P><P>count(distinct field) will return 2 because A will be counted as 1</P></BODY></HTML> Wed, 09 Jul 2014 12:18:44 GMT https://community.qlik.com/t5/QlikView/distinct-function/m-p/738897#M1080243 2014-07-09T12:18:44Z Re: distinct function? https://community.qlik.com/t5/QlikView/distinct-function/m-p/738898#M1080246 <HTML><HEAD></HEAD><BODY><P>It will not allow duplicate values</P></BODY></HTML> Wed, 09 Jul 2014 12:21:18 GMT https://community.qlik.com/t5/QlikView/distinct-function/m-p/738898#M1080246 2014-07-09T12:21:18Z Re: distinct function? https://community.qlik.com/t5/QlikView/distinct-function/m-p/738899#M1080249 <HTML><HEAD></HEAD><BODY><P>see this</P><P></P><P>hope helps</P><P></P><P><A href="https://community.qlik.com/thread/76250">What is the use of Distinct?</A></P><P></P><P><A href="https://community.qlik.com/thread/76265">What is the use of Distinct?</A></P></BODY></HTML> Wed, 09 Jul 2014 13:31:25 GMT https://community.qlik.com/t5/QlikView/distinct-function/m-p/738899#M1080249 fkeuroglian 2014-07-09T13:31:25Z