topic Re: Duplicate Values in QlikView

Duplicate Values

qlikview979 — Wed, 25 Nov 2020 16:16:04 GMT

Hi experts,

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

stalwar1‌ kush141087‌ loveisfail‌

Regards

Mahesh

Re: Duplicate Values

Anil_Babu_Samineni — Thu, 30 Nov 2017 14:01:18 GMT

Either use Pivot Table Or Aggr(FieldName, FieldName)

Re: Duplicate Values

qlikview979 — Thu, 30 Nov 2017 14:06:27 GMT

not working,i need that in Straight table.

Re: Duplicate Values

Anil_Babu_Samineni — Thu, 30 Nov 2017 14:08:11 GMT

Can you show image?

Re: Duplicate Values

qlikview979 — Thu, 30 Nov 2017 14:11:23 GMT

Hi anil,

I got it ,i changed my expression.

mahesh

Re: Duplicate Values

Anil_Babu_Samineni — Thu, 30 Nov 2017 14:51:39 GMT

What you have done? Show us and close this thread

Re: Duplicate Values

qlikview979 — Thu, 30 Nov 2017 15:57:39 GMT

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

Re: Duplicate Values

qlikview979 — Thu, 30 Nov 2017 16:00:55 GMT

Hi all,

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

Mahesh

Re: Duplicate Values

sunny_talwar — Thu, 30 Nov 2017 16:04:42 GMT

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

Re: Duplicate Values

qlikview979 — Thu, 30 Nov 2017 16:10:41 GMT

how can i get that bro ,only duplicate values.

Re: Duplicate Values

sunny_talwar — Thu, 30 Nov 2017 16:12:00 GMT

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

Dim Value

A 10

A 20

B 30

What are you hoping to see as your result?

Re: Duplicate Values

qlikview979 — Thu, 30 Nov 2017 16:16:16 GMT

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

Re: Duplicate Values

sunny_talwar — Thu, 30 Nov 2017 16:17:53 GMT

May be this

Dimension

DimensionField

Expression

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

Re: Duplicate Values

qlikview979 — Thu, 30 Nov 2017 16:34:05 GMT

i have 10 dimensions bro

Re: Duplicate Values

sunny_talwar — Thu, 30 Nov 2017 16:34:47 GMT

So? What am I missing?

Re: Duplicate Values

qlikview979 — Thu, 30 Nov 2017 16:37:08 GMT

i have to restrict the data in dimension level only.

Re: Duplicate Values

sunny_talwar — Thu, 30 Nov 2017 16:40:33 GMT

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

Re: Duplicate Values

qlikview979 — Thu, 30 Nov 2017 16:43:37 GMT

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.

Re: Duplicate Values

sunny_talwar — Thu, 30 Nov 2017 16:51:19 GMT

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

Re: Duplicate Values

qlikview979 — Thu, 30 Nov 2017 16:54:02 GMT

Hi Bro ,Thanks

i got it

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

mahesh