Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts,
How to remove the Unique values from Dimension level in qlik.I need only Duplicate Values.
stalwar1 kush141087 loveisfail
Regards
Mahesh
Hi,
Can you try this
Calculated Dimension
=Aggr(If(Count(DimensionField)>1,DimensionField),DimensionField)
and on dimension tab select following checkbox
Expression
=Sum(ValueField)