topic making queries in QlikView

making queries

Sat, 10 Apr 2010 07:16:58 GMT

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

making queries

Sat, 10 Apr 2010 15:52:51 GMT


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.

making queries

Sun, 11 Apr 2010 07:19:59 GMT

Hi Anthony,

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

Please give another suggestion.

making queries

Anonymous — Sun, 11 Apr 2010 14:42:54 GMT

Hi abdullahkn ,

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

Regards,

Valera

making queries

Mon, 12 Apr 2010 07:40:55 GMT

making queries

Mon, 12 Apr 2010 08:02:27 GMT

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...

making queries

Mon, 12 Apr 2010 08:22:19 GMT

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 .

making queries

Mon, 12 Apr 2010 08:33:25 GMT

Hi Khan,

Can you attach your application.

Regards,

Ravi...

making queries

Mon, 12 Apr 2010 09:07:07 GMT

Hi Ravi,

Here is my application.

making queries

Mon, 12 Apr 2010 09:29:09 GMT

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...