field index in Qlikview

[qlikview979]

Hi all,

How to get only Duplicate Values by using Field index function in   front end level in straight table.

Can any one share sample app.

loveisfail‌stalwar1‌kush141087‌

Regards

Mahesh

[Chanty4u]

try

=fieldvaluecount(FieldName)

[qlikview979]

Bro,

if i use same thing i am getting "-" only.

[tresB]

Put single quotes around field name like: =fieldvaluecount('FieldName')

[qlikview979]

In my dimension inside the column like this Bro

Name

A

A

A

B

B

B

D

E

G

H

J

i want  here only duplicates

Speaker   Name

[qlikview979]

Hi,can any one give suggestions.

[antoniotiman]

Try this in calculated Dimension

Aggr(If(Count(Name) > 1,Name),Name)

and check Suppress Value Null

[tresB]

In a tex tbox, try like:

='Duplicate names : '&Concat( Distinct {<Name={"=Count(Name)>1"}>}Name, ',')

[Chanty4u]

try

like below its working fine to me

=Fieldvaluecount('FieldName') 

single quote

[qlikview979]

I am getting duplicates with unique values also,but i want only duplicates