Duplicate Values

[qlikview979]

Hi experts,

How to remove the Unique values from Dimension level in qlik.I need only Duplicate Values.

stalwar1‌ kush141087‌ loveisfail‌

Regards

Mahesh

[Anil_Babu_Samineni]

Either use Pivot Table Or Aggr(FieldName, FieldName)

[qlikview979]

not working,i need that in Straight table.

[Anil_Babu_Samineni]

Can you show image?

[qlikview979]

Hi anil,

I got it ,i changed my expression.

mahesh

[Anil_Babu_Samineni]

What you have done? Show us and close this thread

[qlikview979]

sorry data goes wrong,

when i select show frequency i can see unique,duplicates ,but i want only duplicates not unique.

i am not able to show data due to security problems.

mahesh

[qlikview979]

Hi all,

My requirement is how to show only Duplicate values in particular dimension in straight table.

Mahesh

[sunny_talwar]

You mean you want to show duplicates only, but only one for each row? or you want to show duplicates in multiple rows?

[qlikview979]

how can i  get that bro ,only duplicate values.