Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
dseelam
Contributor

Dupes

Concern

Hear is the sample QVW With Data I have

I need only row with primary key 566565

     thanks in advance

6 Replies
MVP
MVP

Re: Dupes

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

dseelam
Contributor

Re: Dupes

Manish

I have many Primary keys

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

MVP
MVP

Re: Dupes

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
Contributor

Re: Dupes

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

MVP
MVP

Re: Dupes

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

MVP
MVP

Re: Dupes

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

Community Browser