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

[sunny_talwar]

Hahahahaha how you want to see it? For instance you have this

Dim     Value

A          10

A          20

B          30

B          30

What are you hoping to see as your result?

[qlikview979]

MY SAMPLE DATA

1,A,100

2,B,200

3,A,300

4,D,400

5,D,500

6,E,600

7,F,700

o/p:-

A,400

D,900

[sunny_talwar]

May be this

Dimension

DimensionField

Expression

Sum({<DimensionField = {"=Count(DimensionField) >= 2"}>}ValueField)

[qlikview979]

i have  10 dimensions bro

[sunny_talwar]

So? What am I missing?

[qlikview979]

i have to restrict the data in dimension level only.

[sunny_talwar]

I am not sure I follow.... you want to use calculated dimension?

[qlikview979]

1,A,100

2,B,200

3,A,300

4,D,400

5,D,500

6,E,600

7,F,700

o/p:-

A,400

D,900

Here how can i use calculation condition on product  for only duplicates.

[sunny_talwar]

Here how can i use calculation condition on product  for only duplicates.

What does this even mean Mahesh? I gave you dimension and expression... which should give you the desired output... I have no idea what else are you looking for... you have to elaborate a little bit more here... else we won't be able to offer any help

[qlikview979]

Hi Bro ,Thanks

i got it

=Aggr(if(count(PRODUCT)>=2,PRODUCT),PRODUCT)

mahesh