topic Re: JOIN in QlikView

JOIN

Sat, 30 Nov 2013 12:38:15 GMT

HI,

I need to connect the tables using join

What is the correct way to do it?

The Table in the cloud shows wrong data and blanks.

Sat, 30 Nov 2013 14:48:53 GMT

Thanks for your response, but it does not work well.

All tables should be linked somehow with'' the keys, join etc.. I do not really know how

Sat, 30 Nov 2013 15:11:44 GMT

Hi,

Did you notice that in the table customer, the customers 19, 63, 72 and 77 have no country code.

This is a reason why you see 'blanks' in your chart.

And! CustomerID that you use in your chart is defined in 2 different tabels, in Sales and in Customers.

QlikView does not now that you want only records form your table Sales.

Load additional field in table Sales: CustomerID as SalesCustomerID.

Then replace in your chart CustomerID by SalesCustomerID.

Regards,

Gerrit

Sat, 30 Nov 2013 15:38:28 GMT

Category name column and product name there are some 'blanks (in the Bottom of the table)

Sat, 30 Nov 2013 15:54:33 GMT

Category name column and product name there are some 'blanks (in the Bottom of the table)

Even if I do what you recommended

Sat, 30 Nov 2013 16:02:39 GMT

Hi,

If you did this:

Load additional field in table Sales: CustomerID as SalesCustomerID.

Then replace in your chart CustomerID by SalesCustomerID.

As far as I can see you should be ok.

Regards,

Gerrit

javier_florian — Sat, 30 Nov 2013 18:09:38 GMT

Hi Alon,

I reviewed your qvw file and that is correct, you can see your model like this:

You and only you know your own model, but I recommend you the follow post:

An additional recommendation, in Sales tab you load Sales.xls and SalesHistory.xls, you can invoke an only script like Sales*.xls

-Javier Florian