topic Re: check the duplicate value in QlikView https://community.qlik.com/t5/QlikView/check-the-duplicate-value/m-p/851524#M1008259 <HTML><HEAD></HEAD><BODY><P>The problem is with the cross()&nbsp; table , check from which column you need the transformation??</P></BODY></HTML> Wed, 13 May 2015 11:21:09 GMT avinashelite 2015-05-13T11:21:09Z check the duplicate value https://community.qlik.com/t5/QlikView/check-the-duplicate-value/m-p/851523#M1008257 <HTML><HEAD></HEAD><BODY><P>how to filter duplicate value of same claim no. please refer the given below data.</P><P></P><P>sagara</P><P><IMG alt="Untitled.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/86416_Untitled.jpg" style="max-width: 620px; height: auto;" />.</P><P></P><P>Directory;</P><P>CrossTable(DES, BALANCE, 24)</P><P>LOAD DATE, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; CLDOR, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; CLNO, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; CLMPRD, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; CLSPRD, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; CLBRCOD, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; CLNAME, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; CLDOL, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; CLDORV, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; CLREAS, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; CLTYP, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; CLFDOP, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; CLTYPA, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; CLTYPF, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; CLTYPR, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; CLVIPCOD, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; CLMECOD, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; CLRECTYP, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; CLSUMI, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; CLFROM, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; CLTO, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; CLCLOS, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; CLRISK, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; MECODE, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; CLTECVAL, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; CLOBAL, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; CLAMTPRO, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; CLFPAID, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; CLADJUS, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; CLBAL, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; CLRECOB, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; CLRECAD, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; CLRECR, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; CLRECBL, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; NOD, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; RFOBAL, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; RFPROV, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; RFRECE, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; RFCBAL</P><P>FROM</P><P>[..\..\qlickviwe\Claims\CLM_DATA_2014.QVD]</P><P></P><P></P><P></P><P>sagara</P></BODY></HTML> Wed, 13 May 2015 11:17:22 GMT https://community.qlik.com/t5/QlikView/check-the-duplicate-value/m-p/851523#M1008257 sagaraperera 2015-05-13T11:17:22Z Re: check the duplicate value https://community.qlik.com/t5/QlikView/check-the-duplicate-value/m-p/851524#M1008259 <HTML><HEAD></HEAD><BODY><P>The problem is with the cross()&nbsp; table , check from which column you need the transformation??</P></BODY></HTML> Wed, 13 May 2015 11:21:09 GMT https://community.qlik.com/t5/QlikView/check-the-duplicate-value/m-p/851524#M1008259 avinashelite 2015-05-13T11:21:09Z