topic Re: distinct no for field in QlikView https://community.qlik.com/t5/QlikView/distinct-no-for-field/m-p/1296743#M830143 <HTML><HEAD></HEAD><BODY><P>Front-end ? Try using chart like:</P><P></P><P><SPAN style="font-family: 'courier new', courier;">Straight table:</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">Dim: site</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">Exp: Rowno()</SPAN></P><P></P><P>For script:</P><P></P><P><SPAN style="font-family: 'courier new', courier;">Load </SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; *, </SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #0000ff;">AutoNumber(site) as SiteNo</SPAN></SPAN></P><P><SPAN style="font-family: 'courier new', courier;">From &lt;&gt;;</SPAN></P></BODY></HTML> Thu, 29 Jun 2017 05:52:06 GMT tresB 2017-06-29T05:52:06Z distinct no for field https://community.qlik.com/t5/QlikView/distinct-no-for-field/m-p/1296742#M830142 <HTML><HEAD></HEAD><BODY><P>Hi Team,</P><P></P><P>could any one please suggest how to generate distinct no for site filed here.</P><P>site siteno</P><P>inida 1</P><P>us 2</P><P>kenada 3</P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 232px;"><TBODY><TR><TD height="20" style="border: 0px black; border-image: none;" width="71"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">site</SPAN></TD><TD style="border: 0px black; border-image: none;" width="57"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">state</SPAN></TD><TD style="border: 0px black; border-image: none;" width="66"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">disitnct</SPAN></TD><TD style="border: 0px black; border-image: none;" width="38"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">sales</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">India</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">ap</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">ongole</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">80</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">India</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">ap</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">nell</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">85</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">india</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">bhp</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">paradise</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">23</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">india</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">bhp</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">cellorium</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">45</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">us</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">remedy</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">calom</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">86</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">us</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">remedy</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">siral</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">75</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">kenada</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">kalosa</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">richel</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">66</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">kenada</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">kalosa</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">silaj</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">89</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">kenada</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">sumera</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">aparlak</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">25</SPAN></TD></TR></TBODY></TABLE><P></P><P></P><P></P><P>Thanks,</P><P>Ram.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/distinct-no-for-field/m-p/1296742#M830142 ramachandra_gee 2020-11-25T16:16:04Z Re: distinct no for field https://community.qlik.com/t5/QlikView/distinct-no-for-field/m-p/1296743#M830143 <HTML><HEAD></HEAD><BODY><P>Front-end ? Try using chart like:</P><P></P><P><SPAN style="font-family: 'courier new', courier;">Straight table:</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">Dim: site</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">Exp: Rowno()</SPAN></P><P></P><P>For script:</P><P></P><P><SPAN style="font-family: 'courier new', courier;">Load </SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; *, </SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #0000ff;">AutoNumber(site) as SiteNo</SPAN></SPAN></P><P><SPAN style="font-family: 'courier new', courier;">From &lt;&gt;;</SPAN></P></BODY></HTML> Thu, 29 Jun 2017 05:52:06 GMT https://community.qlik.com/t5/QlikView/distinct-no-for-field/m-p/1296743#M830143 tresB 2017-06-29T05:52:06Z Re: distinct no for field https://community.qlik.com/t5/QlikView/distinct-no-for-field/m-p/1296744#M830144 <HTML><HEAD></HEAD><BODY><P>May be this</P><P>site &amp; ' ' &amp; RowNo() as site</P></BODY></HTML> Thu, 29 Jun 2017 05:52:22 GMT https://community.qlik.com/t5/QlikView/distinct-no-for-field/m-p/1296744#M830144 Anil_Babu_Samineni 2017-06-29T05:52:22Z