topic Re: Dupes in QlikView

Dupes

dseelam — Tue, 22 Apr 2014 18:57:04 GMT

Concern

Hear is the sample QVW With Data I have

I need only row with primary key 566565

thanks in advance

Re: Dupes

MK_QSL — Tue, 22 Apr 2014 19:01:27 GMT

Only({<[Primary key] = {566565}>}[Primary key])

Re: Dupes

dseelam — Tue, 22 Apr 2014 19:02:59 GMT

Manish

I have many Primary keys

I need all the Primary Keys with more than one Con Number

Re: Dupes

maxgro — Tue, 22 Apr 2014 19:09:34 GMT

in chart you can replace your dim [Primary key] with

=if([Primary key]=566565,[Primary key], null())

and then check the flag "Suppress when value is null"

in script you can filter adding a where clause

LOAD [Primary key],

status,

[Con Numbers]

FROM

..............................

Where

[Primary key]=566565;

Re: Dupes

dseelam — Tue, 22 Apr 2014 19:14:10 GMT

Hi Massimo

Thanks for the reply I am not looking for one Primary Key

I am checking for all the primary Keys in my data model with 2 Con Numbers

Re: Dupes

maxgro — Tue, 22 Apr 2014 19:17:06 GMT

Directory;

Source:

load * where cnt > 1;

load [Primary key],

count (distinct [Con Numbers]) as cnt

FROM

[Book1 (1) (1).xlsx]

(ooxml, embedded labels, table is Sheet1)

group by [Primary key];

Table:

Inner Keep (Source)

LOAD [Primary key],

status,

[Con Numbers]

FROM

[Book1 (1) (1).xlsx]

(ooxml, embedded labels, table is Sheet1);

Re: Dupes

MK_QSL — Tue, 22 Apr 2014 19:35:24 GMT

Only({<[Primary key] = {"=COUNT([Con Numbers])>1"}>}[Primary key])