topic Re: Duplicate rows in QlikView https://community.qlik.com/t5/QlikView/Duplicate-rows/m-p/1412846#M427103 <HTML><HEAD></HEAD><BODY><P>through original data feed.. this should only show for A.</P></BODY></HTML> Mon, 23 Oct 2017 11:29:06 GMT pawwy1415 2017-10-23T11:29:06Z Duplicate rows https://community.qlik.com/t5/QlikView/Duplicate-rows/m-p/1412844#M427101 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>We are getting duplicate rows for couple of metrics, e.g. Mt15 and Mt16 is showing against two group A and B but it should show only against A, rest of the metrics are showing against correct group. could you please help what expression we can use to eliminate duplicate rows.</P><P></P><P>Wrong value</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/180548_Capture.PNG" style="height: auto;" /></P><P></P><P></P><P>Expected - it should like below</P><P></P><P><IMG alt="Capture1.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/180549_Capture1.PNG" style="height: auto;" /></P></BODY></HTML> Mon, 23 Oct 2017 11:05:22 GMT https://community.qlik.com/t5/QlikView/Duplicate-rows/m-p/1412844#M427101 pawwy1415 2017-10-23T11:05:22Z Re: Duplicate rows https://community.qlik.com/t5/QlikView/Duplicate-rows/m-p/1412845#M427102 <HTML><HEAD></HEAD><BODY><P>How do we know it should go to group A not to B?</P><P>Tomasz</P></BODY></HTML> Mon, 23 Oct 2017 11:07:58 GMT https://community.qlik.com/t5/QlikView/Duplicate-rows/m-p/1412845#M427102 tomasz_tru 2017-10-23T11:07:58Z Re: Duplicate rows https://community.qlik.com/t5/QlikView/Duplicate-rows/m-p/1412846#M427103 <HTML><HEAD></HEAD><BODY><P>through original data feed.. this should only show for A.</P></BODY></HTML> Mon, 23 Oct 2017 11:29:06 GMT https://community.qlik.com/t5/QlikView/Duplicate-rows/m-p/1412846#M427103 pawwy1415 2017-10-23T11:29:06Z Re: Duplicate rows https://community.qlik.com/t5/QlikView/Duplicate-rows/m-p/1412847#M427104 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>see this snapshot</P><P><IMG alt="remove duplicate rows.jpg" class="jive-image image-1" src="/legacyfs/online/180546_remove duplicate rows.jpg" style="height: auto;" /></P><P>Regards,</P><P>Sahadev</P></BODY></HTML> Mon, 23 Oct 2017 11:31:57 GMT https://community.qlik.com/t5/QlikView/Duplicate-rows/m-p/1412847#M427104 Anonymous 2017-10-23T11:31:57Z Re: Duplicate rows https://community.qlik.com/t5/QlikView/Duplicate-rows/m-p/1412848#M427105 <HTML><HEAD></HEAD><BODY><P>where we should add this logic? </P></BODY></HTML> Mon, 23 Oct 2017 11:53:20 GMT https://community.qlik.com/t5/QlikView/Duplicate-rows/m-p/1412848#M427105 pawwy1415 2017-10-23T11:53:20Z Re: Duplicate rows https://community.qlik.com/t5/QlikView/Duplicate-rows/m-p/1412849#M427106 <HTML><HEAD></HEAD><BODY><P>we don't to derive new column..</P></BODY></HTML> Mon, 23 Oct 2017 11:53:32 GMT https://community.qlik.com/t5/QlikView/Duplicate-rows/m-p/1412849#M427106 pawwy1415 2017-10-23T11:53:32Z Re: Duplicate rows https://community.qlik.com/t5/QlikView/Duplicate-rows/m-p/1412850#M427107 <HTML><HEAD></HEAD><BODY><P>expression is giving error as well<IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/180555_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Mon, 23 Oct 2017 11:56:31 GMT https://community.qlik.com/t5/QlikView/Duplicate-rows/m-p/1412850#M427107 pawwy1415 2017-10-23T11:56:31Z Re: Duplicate rows https://community.qlik.com/t5/QlikView/Duplicate-rows/m-p/1412851#M427108 <HTML><HEAD></HEAD><BODY><P>expression work, but stil giving two rows.</P></BODY></HTML> Mon, 23 Oct 2017 12:03:38 GMT https://community.qlik.com/t5/QlikView/Duplicate-rows/m-p/1412851#M427108 pawwy1415 2017-10-23T12:03:38Z Re: Duplicate rows https://community.qlik.com/t5/QlikView/Duplicate-rows/m-p/1412852#M427109 <HTML><HEAD></HEAD><BODY><P>If it's always A, B's should be removed on data load stage.</P></BODY></HTML> Mon, 23 Oct 2017 12:07:43 GMT https://community.qlik.com/t5/QlikView/Duplicate-rows/m-p/1412852#M427109 tomasz_tru 2017-10-23T12:07:43Z