making queries

[#1]

Dears,

I have two tables the first table contains two fields (product, product code) the second table contained (country,customer,product,value)

I want to join those two tables and make all possible queries anyone here helps me coz I'm new in qlikview

thanks

Regards,

abdullahkn

[#2]

JoinedTable:
load
product,
product code
from tablesource1.qvd
join (you can do left join outter join inner join right join)
load
country,
customer,
product,
value
from tablesource2.qvd;

Now you have to table joined as one and you can do queries from it.

[#3]

Hi Anthony,

i did that but still there is a problem. It joined only two filed product and product Code.

Please give another suggestion.

[Anonymous]

Hi abdullahkn ,

the suggested solution seems correct. Could you explain in details what exactly is not working?

Regards,

Valera

[#5]

Hi Khan,

As per your data structure, if you load the data automatically product will get link (inner Jion). otherwise if you would like to make outer join then you need to use (left or right) as per your requirement. the syntax and all you will find in reference manual.

i hope it will help you and if you don't find solution then attach your application.

Regards,

Ravi...

[#6]

HI Ravi,

the problem in the product filed as it's appear in two tables in the frist tables appear as string and in the fact table appear as number when loaded data i got one filed with two number and string .

[#7]

Hi Khan,

Can you attach your application.

Regards,

Ravi...

[#8]

Hi Ravi,

Here is my application.

[#9 · Accepted solution]

Hi Khan,

Thanks for posting the xls. and just give alias name to product as some othername in product table and make productcode as product in product table, becuase if you see your data this is enough to get resolve your issue. I hope it will help you. Still if you stuck up with issue then tell me how do you want..

Regards,

Ravi...