topic Remove Duplicate values in QlikView https://community.qlik.com/t5/QlikView/Remove-Duplicate-values/m-p/646131#M676094 <HTML><HEAD></HEAD><BODY><P>I have duplicate values in my table, and I am trying to remove them, I have used Distinct load on both the table and the Generic Load Table.&nbsp; <IMG alt="Distinct Values 2.gif" class="jive-image" src="/legacyfs/online/62100_Distinct Values 2.gif" /></P></BODY></HTML> Wed, 09 Jul 2014 18:14:58 GMT 2014-07-09T18:14:58Z Remove Duplicate values https://community.qlik.com/t5/QlikView/Remove-Duplicate-values/m-p/646131#M676094 <HTML><HEAD></HEAD><BODY><P>I have duplicate values in my table, and I am trying to remove them, I have used Distinct load on both the table and the Generic Load Table.&nbsp; <IMG alt="Distinct Values 2.gif" class="jive-image" src="/legacyfs/online/62100_Distinct Values 2.gif" /></P></BODY></HTML> Wed, 09 Jul 2014 18:14:58 GMT https://community.qlik.com/t5/QlikView/Remove-Duplicate-values/m-p/646131#M676094 2014-07-09T18:14:58Z Re: Remove Duplicate values https://community.qlik.com/t5/QlikView/Remove-Duplicate-values/m-p/646132#M676095 <HTML><HEAD></HEAD><BODY><P>better if you can post your qlik doc</P></BODY></HTML> Wed, 09 Jul 2014 18:22:27 GMT https://community.qlik.com/t5/QlikView/Remove-Duplicate-values/m-p/646132#M676095 maxgro 2014-07-09T18:22:27Z Re: Remove Duplicate values https://community.qlik.com/t5/QlikView/Remove-Duplicate-values/m-p/646133#M676096 <HTML><HEAD></HEAD><BODY><P>Try trimming your field.&nbsp; It looks like this is a list box, so the 'Field' under 'General' could be an '&lt;Expression&gt;' that equals =Trim(YourFieldName) or better then that, if this is the issue, you could trim it in the script so all of your data is trimmed</P></BODY></HTML> Wed, 09 Jul 2014 18:26:53 GMT https://community.qlik.com/t5/QlikView/Remove-Duplicate-values/m-p/646133#M676096 joshabbott 2014-07-09T18:26:53Z Re: Remove Duplicate values https://community.qlik.com/t5/QlikView/Remove-Duplicate-values/m-p/646134#M676097 <HTML><HEAD></HEAD><BODY><P>Thank You!</P></BODY></HTML> Wed, 09 Jul 2014 18:32:41 GMT https://community.qlik.com/t5/QlikView/Remove-Duplicate-values/m-p/646134#M676097 2014-07-09T18:32:41Z