Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filter Table based on values in another table

Hi,

Explaining scenario:

Table 1 has 20 rows with 20 Different Months.

Now My second table has values for last 10-20 Years, but i need the data for only those Months which exists in Table 1.

Currently I use right/left join for filtering the data, is there a better way as sometime the data does not come right..

Regards,

Chinmay

6 Replies
maneshkhottcpl
Partner - Creator III
Partner - Creator III

Hi,

I understand ur issue. U need exists function to be used in where clause

let me explain

A:

Load A as a1, B, C from XX;

B:

Load A,b1,c1 from YY where exists(a1,A);

this will help u.

The EXISTS(FiledName, Expression) will load the data from YYonly exists in XX .

Is that clear ur issue?

Regards

Manesh

Not applicable
Author

Yes...

Thanks a lot 😄

There is a lot to explore in QlikView

Not applicable
Author

Hi,

Can you please explain what will be in the expression ?

where exist(FieldValue,Expression)

-Chinmay

Not applicable
Author

Requesting someone to explain how I can use where exists to achieve the functionality

maneshkhottcpl
Partner - Creator III
Partner - Creator III

Hi,

The function exists will match the current table field value with previously loaded field value of same table or different table.

i.e. Exists(FIeld_PreviouslyLpaded,CurrentFieldValue)

it will load the record if current field value is present in PreviouslyLpaded.

Note - U can also veryfy my post as an answer.

Regards

Manesh

Not applicable
Author

Hi,

I am kind of new to all this...

Finding it difficult to understand the syntax, if someone can explain with a small example it would be great.

I am not able to understand whats the difference in using keep and exists.

Regards,

Chinmay