Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcement: We have made updates to resolve a Page Not Found error. If you still get this error, please let us know in the Community Corner.
qlikview979
Valued Contributor

field index in Qlikview

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.

loveisfailstalwar1kush141087

Regards

Mahesh

13 Replies
Chanty4u
Esteemed Contributor III

Re: field index in Qlikview

try

=fieldvaluecount(FieldName)

qlikview979
Valued Contributor

Re: field index in Qlikview

Bro,

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

MVP
MVP

Re: field index in Qlikview

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

qlikview979
Valued Contributor

Re: field index in Qlikview

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
Valued Contributor

Re: field index in Qlikview

Hi,can any one give suggestions.

Highlighted
antoniotiman
Honored Contributor III

Re: field index in Qlikview

Try this in calculated Dimension

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

and check Suppress Value Null

MVP
MVP

Re: field index in Qlikview

In a tex tbox, try like:

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

Chanty4u
Esteemed Contributor III

Re: field index in Qlikview

try

like below its working fine to me

=Fieldvaluecount('FieldName') 

single quote

qlikview979
Valued Contributor

Re: field index in Qlikview

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