Dupes

[dseelam]

Concern

Hear is the sample QVW With Data I have

I need only row with primary key 566565

     thanks in advance

[MK_QSL]

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

[dseelam]

Manish

I have many Primary keys

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

[maxgro]

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;

[dseelam]

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

[maxgro]

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);

[MK_QSL]

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