topic Re: Count Duplicate values in QlikView https://community.qlik.com/t5/QlikView/Count-Duplicate-values/m-p/555212#M207400 <HTML><HEAD></HEAD><BODY><P>hi, PFA</P></BODY></HTML> Thu, 31 Oct 2013 13:33:52 GMT israrkhan 2013-10-31T13:33:52Z Count Duplicate values https://community.qlik.com/t5/QlikView/Count-Duplicate-values/m-p/555209#M207397 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I need output as following as data with me is ID, FID, please help</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">ID</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">FID</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Output</STRONG></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;">3 (As 10 3 times in FID)</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;">2 (As 20 2 times in FID) and so on</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">30</TD><TD style="padding: 2px;">3</TD></TR><TR><TD style="padding: 2px;">4</TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;">3</TD></TR><TR><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">6</TD><TD style="padding: 2px;">30</TD><TD style="padding: 2px;">3</TD></TR><TR><TD style="padding: 2px;">7</TD><TD style="padding: 2px;">40</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">8</TD><TD style="padding: 2px;">30</TD><TD style="padding: 2px;">3</TD></TR><TR><TD style="padding: 2px;">9</TD><TD style="padding: 2px;">50</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">10</TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;">3</TD></TR></TBODY></TABLE></BODY></HTML> Thu, 31 Oct 2013 13:16:23 GMT https://community.qlik.com/t5/QlikView/Count-Duplicate-values/m-p/555209#M207397 2013-10-31T13:16:23Z Re: Count Duplicate values https://community.qlik.com/t5/QlikView/Count-Duplicate-values/m-p/555210#M207398 <HTML><HEAD></HEAD><BODY><P>Hi Patel,</P><P></P><P>Try this expression:</P><P><SPAN style="font-size: 8pt;">&nbsp; </SPAN></P><P>=<SPAN style="font-size: 8pt;"><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">TOTAL</SPAN><SPAN style="font-size: 8pt;"> &lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">FID</SPAN><SPAN style="font-size: 8pt;">&gt; </SPAN><SPAN style="color: #800000; font-size: 8pt;">FID</SPAN><SPAN style="font-size: 8pt;">) </SPAN></SPAN></P><P></P><P>Regards,</P><P>Vincent</P><P><BR /> </P></BODY></HTML> Thu, 31 Oct 2013 13:23:32 GMT https://community.qlik.com/t5/QlikView/Count-Duplicate-values/m-p/555210#M207398 vincent_ardiet 2013-10-31T13:23:32Z Re: Count Duplicate values https://community.qlik.com/t5/QlikView/Count-Duplicate-values/m-p/555211#M207399 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>If you want to do that on expression: </P><P></P><P>Count(TOTAL &lt;FID&gt; FID)</P><P></P><P>If you want to do that on script:</P><P>TEST:</P><P>LOAD * INLINE [</P><P> ID, FID</P><P>1, 10</P><P>2, 20 </P><P>3, 30</P><P>4, 10</P><P>5, 20</P><P>6, 30</P><P>7, 40</P><P>8, 30</P><P>9, 50</P><P>10, 10</P><P>];</P><P></P><P></P><P>Join(TEST)</P><P>TEST2:</P><P>LOAD</P><P>&nbsp; FID,</P><P>&nbsp; Count(FID)as tt</P><P>Resident TEST</P><P>Group By FID</P><P>;</P><P></P><P>Regards,</P><P>Aurélien</P></BODY></HTML> Thu, 31 Oct 2013 13:27:39 GMT https://community.qlik.com/t5/QlikView/Count-Duplicate-values/m-p/555211#M207399 Aurelien_Martinez 2013-10-31T13:27:39Z Re: Count Duplicate values https://community.qlik.com/t5/QlikView/Count-Duplicate-values/m-p/555212#M207400 <HTML><HEAD></HEAD><BODY><P>hi, PFA</P></BODY></HTML> Thu, 31 Oct 2013 13:33:52 GMT https://community.qlik.com/t5/QlikView/Count-Duplicate-values/m-p/555212#M207400 israrkhan 2013-10-31T13:33:52Z