topic Re: Getting double records in QlikView https://community.qlik.com/t5/QlikView/Getting-double-records/m-p/1370199#M418878 <HTML><HEAD></HEAD><BODY><P>Check the Suppress when value is null for <STRONG>ShipmentNo</STRONG></P></BODY></HTML> Fri, 05 May 2017 07:05:44 GMT Anil_Babu_Samineni 2017-05-05T07:05:44Z Getting double records https://community.qlik.com/t5/QlikView/Getting-double-records/m-p/1370198#M418877 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>I don't understand why i am getting double records for shipment No fields .. all shipment no getting double records here.</P><P></P><P>I am just giving one record sample</P><P></P><P>Can you please look into here.</P><P></P><P></P><P>Thanks</P></BODY></HTML> Fri, 05 May 2017 06:45:34 GMT https://community.qlik.com/t5/QlikView/Getting-double-records/m-p/1370198#M418877 prma7799 2017-05-05T06:45:34Z Re: Getting double records https://community.qlik.com/t5/QlikView/Getting-double-records/m-p/1370199#M418878 <HTML><HEAD></HEAD><BODY><P>Check the Suppress when value is null for <STRONG>ShipmentNo</STRONG></P></BODY></HTML> Fri, 05 May 2017 07:05:44 GMT https://community.qlik.com/t5/QlikView/Getting-double-records/m-p/1370199#M418878 Anil_Babu_Samineni 2017-05-05T07:05:44Z Re: Getting double records https://community.qlik.com/t5/QlikView/Getting-double-records/m-p/1370200#M418879 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>find the attached file</P></BODY></HTML> Fri, 05 May 2017 07:20:04 GMT https://community.qlik.com/t5/QlikView/Getting-double-records/m-p/1370200#M418879 qlikview979 2017-05-05T07:20:04Z Re: Getting double records https://community.qlik.com/t5/QlikView/Getting-double-records/m-p/1370201#M418880 <HTML><HEAD></HEAD><BODY><P>Can you upload your QVDs?</P><P></P><P>I am assuming when you are joining the two tables is where you are doubling the data.</P><P></P><P>Thanks</P></BODY></HTML> Fri, 05 May 2017 07:23:52 GMT https://community.qlik.com/t5/QlikView/Getting-double-records/m-p/1370201#M418880 jackhertel 2017-05-05T07:23:52Z Re: Getting double records https://community.qlik.com/t5/QlikView/Getting-double-records/m-p/1370202#M418881 <HTML><HEAD></HEAD><BODY><P>may be this</P><P></P><P>click on first dimention(Customer_Code) ---&gt;click on Edit </P><P></P><P>write the condition like this</P><P></P><P>=if(len(Customer_Code)&gt;0,Customer_Code) </P></BODY></HTML> Fri, 05 May 2017 08:09:09 GMT https://community.qlik.com/t5/QlikView/Getting-double-records/m-p/1370202#M418881 qlikview979 2017-05-05T08:09:09Z