topic A newbie question about using data from a linked table in QlikView

A newbie question about using data from a linked table

Wed, 30 Mar 2011 06:12:20 GMT

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

Wed, 30 Mar 2011 06:44:01 GMT

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

Wed, 30 Mar 2011 06:51:21 GMT

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';

Wed, 30 Mar 2011 23:12:07 GMT

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