topic Re: field index in Qlikview in QlikView https://community.qlik.com/t5/QlikView/field-index-in-Qlikview/m-p/1419350#M801600 <HTML><HEAD></HEAD><BODY><P>Put <STRONG>single quotes</STRONG> around field name like: <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=fieldvaluecount('FieldName')</SPAN></P></BODY></HTML> Mon, 04 Dec 2017 10:15:28 GMT tresB 2017-12-04T10:15:28Z field index in Qlikview https://community.qlik.com/t5/QlikView/field-index-in-Qlikview/m-p/1419347#M801597 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>How to get only Duplicate Values by using Field index function in&nbsp;&nbsp; front end level in straight table.</P><P></P><P>Can any one share sample app.</P><P><A href="https://community.qlik.com/qlik-users/218859" target="_blank">loveisfail</A>‌<A href="https://community.qlik.com/qlik-users/171708" target="_blank">stalwar1</A>‌<A href="https://community.qlik.com/qlik-users/57428" target="_blank">kush141087</A>‌</P><P></P><P></P><P>Regards</P><P>Mahesh</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/field-index-in-Qlikview/m-p/1419347#M801597 qlikview979 2020-11-25T16:16:04Z Re: field index in Qlikview https://community.qlik.com/t5/QlikView/field-index-in-Qlikview/m-p/1419348#M801598 <HTML><HEAD></HEAD><BODY><P>try </P><P>=fieldvaluecount(FieldName)</P></BODY></HTML> Mon, 04 Dec 2017 10:05:17 GMT https://community.qlik.com/t5/QlikView/field-index-in-Qlikview/m-p/1419348#M801598 Chanty4u 2017-12-04T10:05:17Z Re: field index in Qlikview https://community.qlik.com/t5/QlikView/field-index-in-Qlikview/m-p/1419349#M801599 <HTML><HEAD></HEAD><BODY><P>Bro,</P><P></P><P>if i use same thing i am getting "-" only.</P></BODY></HTML> Mon, 04 Dec 2017 10:11:25 GMT https://community.qlik.com/t5/QlikView/field-index-in-Qlikview/m-p/1419349#M801599 qlikview979 2017-12-04T10:11:25Z Re: field index in Qlikview https://community.qlik.com/t5/QlikView/field-index-in-Qlikview/m-p/1419350#M801600 <HTML><HEAD></HEAD><BODY><P>Put <STRONG>single quotes</STRONG> around field name like: <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=fieldvaluecount('FieldName')</SPAN></P></BODY></HTML> Mon, 04 Dec 2017 10:15:28 GMT https://community.qlik.com/t5/QlikView/field-index-in-Qlikview/m-p/1419350#M801600 tresB 2017-12-04T10:15:28Z Re: field index in Qlikview https://community.qlik.com/t5/QlikView/field-index-in-Qlikview/m-p/1419351#M801601 <HTML><HEAD></HEAD><BODY><P>In my dimension inside the column like this Bro</P><P></P><P></P><P>Name</P><P>A</P><P>A</P><P>A</P><P>B</P><P>B</P><P>B</P><P>D</P><P>E</P><P>G</P><P>H</P><P>J</P><P></P><P>i want&nbsp; here only duplicates</P><P></P><P></P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 206pt;" width="275"><TBODY><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="height: 12.75pt; width: 206pt;" width="275">Speaker&nbsp;&nbsp; Name</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 04 Dec 2017 10:24:56 GMT https://community.qlik.com/t5/QlikView/field-index-in-Qlikview/m-p/1419351#M801601 qlikview979 2017-12-04T10:24:56Z Re: field index in Qlikview https://community.qlik.com/t5/QlikView/field-index-in-Qlikview/m-p/1419352#M801602 <HTML><HEAD></HEAD><BODY><P>Hi,can any one give suggestions.</P></BODY></HTML> Mon, 04 Dec 2017 10:28:48 GMT https://community.qlik.com/t5/QlikView/field-index-in-Qlikview/m-p/1419352#M801602 qlikview979 2017-12-04T10:28:48Z Re: field index in Qlikview https://community.qlik.com/t5/QlikView/field-index-in-Qlikview/m-p/1419353#M801603 <HTML><HEAD></HEAD><BODY><P>Try this in calculated Dimension</P><P>Aggr(If(Count(Name) &gt; 1,Name),Name)</P><P>and check Suppress Value Null</P></BODY></HTML> Mon, 04 Dec 2017 10:31:32 GMT https://community.qlik.com/t5/QlikView/field-index-in-Qlikview/m-p/1419353#M801603 antoniotiman 2017-12-04T10:31:32Z Re: field index in Qlikview https://community.qlik.com/t5/QlikView/field-index-in-Qlikview/m-p/1419354#M801604 <HTML><HEAD></HEAD><BODY><P>In a tex tbox, try like:</P><P></P><P>='Duplicate names : '&amp;<STRONG>Concat( Distinct {&lt;Name={"=Count(Name)&gt;1"}&gt;}Name, ',')</STRONG></P></BODY></HTML> Mon, 04 Dec 2017 10:31:45 GMT https://community.qlik.com/t5/QlikView/field-index-in-Qlikview/m-p/1419354#M801604 tresB 2017-12-04T10:31:45Z Re: field index in Qlikview https://community.qlik.com/t5/QlikView/field-index-in-Qlikview/m-p/1419355#M801605 <HTML><HEAD></HEAD><BODY><P>try </P><P>like below its working fine to me</P><P></P><P>=Fieldvaluecount('FieldName')&nbsp; </P><P></P><P>single quote </P></BODY></HTML> Mon, 04 Dec 2017 10:31:52 GMT https://community.qlik.com/t5/QlikView/field-index-in-Qlikview/m-p/1419355#M801605 Chanty4u 2017-12-04T10:31:52Z Re: field index in Qlikview https://community.qlik.com/t5/QlikView/field-index-in-Qlikview/m-p/1419356#M801606 <HTML><HEAD></HEAD><BODY><P>I am getting duplicates with unique values also,but i want only duplicates</P></BODY></HTML> Mon, 04 Dec 2017 10:49:15 GMT https://community.qlik.com/t5/QlikView/field-index-in-Qlikview/m-p/1419356#M801606 qlikview979 2017-12-04T10:49:15Z Re: field index in Qlikview https://community.qlik.com/t5/QlikView/field-index-in-Qlikview/m-p/1419357#M801607 <HTML><HEAD></HEAD><BODY><P>Just check below thread </P><P></P><P><A href="https://community.qlik.com/thread/70101">Find duplicate records</A></P></BODY></HTML> Mon, 04 Dec 2017 12:01:12 GMT https://community.qlik.com/t5/QlikView/field-index-in-Qlikview/m-p/1419357#M801607 Chanty4u 2017-12-04T12:01:12Z Re: field index in Qlikview https://community.qlik.com/t5/QlikView/field-index-in-Qlikview/m-p/1419358#M801608 <HTML><HEAD></HEAD><BODY><P>May be explain with some inputs and result set needed ??</P></BODY></HTML> Mon, 04 Dec 2017 12:12:49 GMT https://community.qlik.com/t5/QlikView/field-index-in-Qlikview/m-p/1419358#M801608 Anil_Babu_Samineni 2017-12-04T12:12:49Z Re: field index in Qlikview https://community.qlik.com/t5/QlikView/field-index-in-Qlikview/m-p/1419359#M801609 <HTML><HEAD></HEAD><BODY><P>Hi all </P><P></P><P>Here i attached sample data</P><P><A href="https://community.qlik.com/message/1393224">Association in straight table</A></P></BODY></HTML> Mon, 04 Dec 2017 12:48:08 GMT https://community.qlik.com/t5/QlikView/field-index-in-Qlikview/m-p/1419359#M801609 qlikview979 2017-12-04T12:48:08Z Re: field index in Qlikview https://community.qlik.com/t5/QlikView/field-index-in-Qlikview/m-p/1419360#M801610 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have given mock up data</P><P></P><P><A href="https://community.qlik.com/message/1393224">Association in straight table</A></P><P>please help on this </P><P></P><P></P><P>Mahesh</P></BODY></HTML> Mon, 04 Dec 2017 14:50:28 GMT https://community.qlik.com/t5/QlikView/field-index-in-Qlikview/m-p/1419360#M801610 qlikview979 2017-12-04T14:50:28Z