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

[rugveddhuri]

Hi,
Can you try this

Calculated Dimension

=Aggr(If(Count(DimensionField)>1,DimensionField),DimensionField)

and on dimension tab select following checkbox

Expression

=Sum(ValueField)