A newbie question about using data from a linked table

[#1]

Hi I'm new to Qlikview, I'd like to ask about how to use data from another linked table.

For example:

Table_A has a unique ID called " A_num" and a field "switch" which can be 0 or 1 only.

Table_B has unique ID called " B_num" and "QTY" stands for quantity.

I've linked these 2 tables by entering "Load A_num as B_num". but how should I load the data to show IDs and QTY in Table_B when switch is 1?

Cheers

[#2]

just clicking 1 in switch isn't showing right data?

[#3]

ahh now i got it.

first you need do join 2 tables:
left join(table1);
load * resident table2;

And then load all 1 in switch:
load * resident table1;
where switch='1';

[#4]

Thanks for your reply,

I'd like to update the problem:

I'm actually loading data from 2 QVD files, lets say Sales.qvd and Product.qvd.

- Sales.qvd contains "SalesID" which is unique key field, and "Condition" is a field can be only 0 or 1.

- Product.qvd has ProductID as unique key field, and one field called "QTY".

SalesID and ProductID are the same.

I'd like to create a pivot chart that display QTY by ID when Condition = 1.

How should I write the script to achieve this?

Cheers