Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Concern
Hear is the sample QVW With Data I have
I need only row with primary key 566565
thanks in advance
Only({<[Primary key] = {566565}>}[Primary key])
Manish
I have many Primary keys
I need all the Primary Keys with more than one Con Number
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;
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
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);
Only({<[Primary key] = {"=COUNT([Con Numbers])>1"}>}[Primary key])