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.
Not applicable

retrieve just some values from two fields with exists

hello

i want to retrieve juste a some values from two fields

load * INLINE [

RECEIVER_REPORTING_PARTY_NAME

DC_NY

];

Load * INLINE [

CONFIRMATION_STATUS

TraMarket

TraPaper

] ;

in the load instruction :

WHERE Exists(RECEIVER_REPORTING_PARTY_NAME, CONFIRMATION_STATUS)'.

but it seems not work because in the GUI, i have  all values for the field CONFIRMATION_STATUS

Regards,

1 Solution

Accepted Solutions
Not applicable

Re: retrieve juste some values from two fields with exists

thanks massimo grossi.

yes i will try it.

for my problem i thinks i can do this :

WHERE Exists(RECEIVER_REPORTING_PARTY_NAME ) and Exist (CONFIRMATION_STATUS)

i will keep you updated

3 Replies
Not applicable

Re: retrieve juste some values from two fields with exists

Generally In the above example there is no data to be loaded because RECEIVER_REPORTING_PARTY_NAME, CONFIRMATION_STATUS don't have common values on the Inline tables.

The Exists will work only to load the common values or not with given field names.

As per my understnading, you need to load only specific values & list of values are static, try like below:

FIELDVALUELISTTABLE:

LOAD * INLINE [

FIleterValues

value1

value2

value3

];

LOAD

     Field1,

     Field2

     ..

     ..

     ..

     ..

From TableName.qvd

Where ( FilterValues , [FieldNameapply the filter] );

DROP Table FIELDVALUELISTTABLE;

If you still have questions, please post script and clearly explain the requirements & whats probelm u r facing.

MVP
MVP

Re: retrieve juste some values from two fields with exists

try this to understand how exists works


a:

load * INLINE [

RECEIVER_REPORTING_PARTY_NAME

DC_NY

TraMarket

];

b:

Load * INLINE [

CONFIRMATION_STATUS

TraMarket

TraPaper

]

WHERE Exists(RECEIVER_REPORTING_PARTY_NAME, CONFIRMATION_STATUS);

Not applicable

Re: retrieve juste some values from two fields with exists

thanks massimo grossi.

yes i will try it.

for my problem i thinks i can do this :

WHERE Exists(RECEIVER_REPORTING_PARTY_NAME ) and Exist (CONFIRMATION_STATUS)

i will keep you updated

Community Browser