topic Join Problem in QlikView

Join Problem

Sat, 13 Jun 2009 05:05:46 GMT

I have two tables, one with Part Number Master data and one with sales history. I am using unquallify to link the table with the part number. I need to see "all" part numbers in the master table, not just ones that match the sales table. I have tried various joins but I must be doing something wrong. Help!

Thanks,
Stephen

Join Problem

Sat, 13 Jun 2009 12:03:52 GMT

Hi,

I`m not sure, I understand your query.

Part_No_Master:

Load Part_No,

Part_Desc,

Part_Reg

From Part_Number ;

Left Join

Load Part_No,

Sales,

Sales_Rep

From Sales;

Above should help you get all the Part numbers from Part Master.

Hope so this would help you, if this doesnt solve your purpose.

Plz post sample of your data with explanantion.

- Sridhar

Join Problem

Sat, 13 Jun 2009 15:51:10 GMT

Hi,

or better (I think) leave out the "left join" and let Qlikview do the linking of the two tables. Make sure the names of the PartNumber is the same in the tables.

So just load the two tables and you can have all the items from the master table in e.g. a list box.

regards,
Walter.