topic Filter Table based on values in another table in QlikView

Filter Table based on values in another table

Thu, 24 Feb 2011 11:56:36 GMT

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

Filter Table based on values in another table

maneshkhottcpl — Thu, 24 Feb 2011 12:05:31 GMT

Hi,

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

let me explain

Load A as a1, B, C from XX;

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

Filter Table based on values in another table

Thu, 24 Feb 2011 12:40:00 GMT

Yes...

Thanks a lot 😄

There is a lot to explore in QlikView

Filter Table based on values in another table

Thu, 24 Feb 2011 13:02:19 GMT

Hi,

Can you please explain what will be in the expression ?

where exist(FieldValue,Expression)

-Chinmay

Filter Table based on values in another table

Mon, 28 Feb 2011 10:59:18 GMT

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

Filter Table based on values in another table

maneshkhottcpl — Mon, 28 Feb 2011 14:09:52 GMT

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

Filter Table based on values in another table

Tue, 01 Mar 2011 10:22:25 GMT

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