topic Re: What is the use of Distinct? in QlikView https://community.qlik.com/t5/QlikView/What-is-the-use-of-Distinct/m-p/411225#M153086 <HTML><HEAD></HEAD><BODY><P>Distinct keyword will eliminate the duplicate records...</P><P></P><P></P><P>do u have duplicate id's in your database?</P><P></P><P>HTH</P><P>Sushil</P></BODY></HTML> Tue, 02 Apr 2013 07:13:30 GMT sushil353 2013-04-02T07:13:30Z What is the use of Distinct? https://community.qlik.com/t5/QlikView/What-is-the-use-of-Distinct/m-p/411224#M153085 <HTML><HEAD></HEAD><BODY><P>Example:</P><P>Tab1:</P><P>Load ID,Name, Dept</P><P>from a.xls;</P><P></P><P>Tab2:</P><P>Load disntict ID, Name, Dept</P><P>from a.xls;</P><P></P><P>Both brings the same result. What is the use of distinct keyword?</P></BODY></HTML> Tue, 02 Apr 2013 07:11:58 GMT https://community.qlik.com/t5/QlikView/What-is-the-use-of-Distinct/m-p/411224#M153085 Anonymous 2013-04-02T07:11:58Z Re: What is the use of Distinct? https://community.qlik.com/t5/QlikView/What-is-the-use-of-Distinct/m-p/411225#M153086 <HTML><HEAD></HEAD><BODY><P>Distinct keyword will eliminate the duplicate records...</P><P></P><P></P><P>do u have duplicate id's in your database?</P><P></P><P>HTH</P><P>Sushil</P></BODY></HTML> Tue, 02 Apr 2013 07:13:30 GMT https://community.qlik.com/t5/QlikView/What-is-the-use-of-Distinct/m-p/411225#M153086 sushil353 2013-04-02T07:13:30Z Re: What is the use of Distinct? https://community.qlik.com/t5/QlikView/What-is-the-use-of-Distinct/m-p/411226#M153087 <HTML><HEAD></HEAD><BODY><P>Yes , i have duplicate values to ID column.</P></BODY></HTML> Tue, 02 Apr 2013 07:45:25 GMT https://community.qlik.com/t5/QlikView/What-is-the-use-of-Distinct/m-p/411226#M153087 Anonymous 2013-04-02T07:45:25Z Re: What is the use of Distinct? https://community.qlik.com/t5/QlikView/What-is-the-use-of-Distinct/m-p/411227#M153088 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P></P><P>If&nbsp; you use disinct load then&nbsp; duplicate records are eliminated. If you have duplicates in combination of </P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">ID,Name, Dept then qlikview will eliminate the duplicate records without using distinct.</SPAN></P></BODY></HTML> Fri, 26 Sep 2014 11:59:12 GMT https://community.qlik.com/t5/QlikView/What-is-the-use-of-Distinct/m-p/411227#M153088 2014-09-26T11:59:12Z