topic Re: retrieve juste some values from two fields with exists in QlikView

retrieve just some values from two fields with exists

Tue, 23 Jun 2015 08:40:33 GMT

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,

Re: retrieve juste some values from two fields with exists

Tue, 23 Jun 2015 11:36:37 GMT

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.

Re: retrieve juste some values from two fields with exists

maxgro — Tue, 23 Jun 2015 12:06:50 GMT

try this to understand how exists works

load * INLINE [

RECEIVER_REPORTING_PARTY_NAME

DC_NY

TraMarket

];

Load * INLINE [

CONFIRMATION_STATUS

TraMarket

TraPaper

]

WHERE Exists(RECEIVER_REPORTING_PARTY_NAME, CONFIRMATION_STATUS);

Re: retrieve juste some values from two fields with exists

Tue, 23 Jun 2015 22:00:35 GMT

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