topic Re: Eliminate duplicate's in QlikView https://community.qlik.com/t5/QlikView/Eliminate-duplicate-s/m-p/108539#M751157 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Try using Load Distinct in script</SPAN></P></BODY></HTML> Mon, 05 Nov 2018 15:29:26 GMT wade12 2018-11-05T15:29:26Z Eliminate duplicate's https://community.qlik.com/t5/QlikView/Eliminate-duplicate-s/m-p/108538#M751156 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hi,</SPAN></P><P><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"> </SPAN></P><P><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I have a question- Suppose for particular column(say id) we have different marks in another column. But my question is if&nbsp; I am having same id with same marks while calculating average and percentage am not getting the right value because of that duplication. Can you tell me how to eliminate that please respond asap.Thanks!!</SPAN></P><P></P><P></P><P><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Marks</SPAN></P><P><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">CD-IM22&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12</SPAN></P><P><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"> CD-IM22&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P><P><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">CD-IM22&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12 </SPAN></P><P></P><P><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Like this I have when I am doing the avg and percentage in the expression it is taking three- 12's instead of one-12 .How to eliminate that one. Please let me know. Anything we can do in scripting ??</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Eliminate-duplicate-s/m-p/108538#M751156 Pujitha 2020-11-25T16:16:04Z Re: Eliminate duplicate's https://community.qlik.com/t5/QlikView/Eliminate-duplicate-s/m-p/108539#M751157 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Try using Load Distinct in script</SPAN></P></BODY></HTML> Mon, 05 Nov 2018 15:29:26 GMT https://community.qlik.com/t5/QlikView/Eliminate-duplicate-s/m-p/108539#M751157 wade12 2018-11-05T15:29:26Z