topic Re: Duplicated rows in QlikView https://community.qlik.com/t5/QlikView/Duplicated-rows/m-p/1070949#M357714 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Another options is to add list boxes and tick the frequency option.</P><P></P><P>Mark</P></BODY></HTML> Mon, 08 Feb 2016 13:27:06 GMT Mark_Little 2016-02-08T13:27:06Z Duplicated rows https://community.qlik.com/t5/QlikView/Duplicated-rows/m-p/1070947#M357712 <HTML><HEAD></HEAD><BODY><P>Fellows,</P><P></P><P>My script:</P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_14549374649511546" jivemacro_uid="_14549374649511546"> <P>LOAD * INLINE [</P> <P>&nbsp;&nbsp;&nbsp; F1, F2</P> <P>&nbsp;&nbsp;&nbsp; A, 1</P> <P>&nbsp;&nbsp;&nbsp; A, 1</P> <P>&nbsp;&nbsp;&nbsp; B, 2</P> <P>&nbsp;&nbsp;&nbsp; C, 3</P> <P>];</P> </PRE><P></P><P>My table:</P><P><IMG alt="a.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/113891_a.png" style="height: auto;" /></P><P></P><P>Issue: How without loading the script and using rowno() I should know that there is a duplicated row?</P><P></P><P>Thank you!</P></BODY></HTML> Mon, 08 Feb 2016 13:19:47 GMT https://community.qlik.com/t5/QlikView/Duplicated-rows/m-p/1070947#M357712 MindaugasBacius 2016-02-08T13:19:47Z Re: Duplicated rows https://community.qlik.com/t5/QlikView/Duplicated-rows/m-p/1070948#M357713 <HTML><HEAD></HEAD><BODY><P>I have just got an idea with Pivot table and Count function.</P></BODY></HTML> Mon, 08 Feb 2016 13:23:37 GMT https://community.qlik.com/t5/QlikView/Duplicated-rows/m-p/1070948#M357713 MindaugasBacius 2016-02-08T13:23:37Z Re: Duplicated rows https://community.qlik.com/t5/QlikView/Duplicated-rows/m-p/1070949#M357714 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Another options is to add list boxes and tick the frequency option.</P><P></P><P>Mark</P></BODY></HTML> Mon, 08 Feb 2016 13:27:06 GMT https://community.qlik.com/t5/QlikView/Duplicated-rows/m-p/1070949#M357714 Mark_Little 2016-02-08T13:27:06Z