combining 3 different excel sheets

thanhphongle — Mon, 02 Nov 2015 12:47:28 GMT

Hello community,

I have three different sheets:

Sheet 1: Customerinformation

Customer ID	Customername	Country
100001	Johnny Fish Market	Japan
100002	Beef Steak Club	USA
100003	Fruit Passion	Spain
100004	Vegiland	Germany

Sheet 2: Invoiceinformation

CustomerID	Customername	Product	Invoice	Year
100001	Johnny Fish Market	Salmon	1000	2013
100002	Beef Steak Club	Beef	2000	2013
100003	Fruit Passion	Banana	3000	2013
100004	Vegiland	Tofu	4000	2013
100001	Johnny Fish Market	Tuna	2000	2014
100002	Beef Steak Club	Porc	3000	2014
100001	Johnny Fish Market	Octopus	1000	2015
100004	Vegiland	Soja	2000	2015
100001	Johnny Fish Market	Seatongue	3000	2016

Sheet 3: Transportinformation

CustomerID	Customername	Transportagency	Location
100001	Johnny Fish Market	Shipping Ltd	Tokyo
100002	Beef Steak Club	Meat Transport Ltd	New York
100003	Fruit Passion	Fruit Shuttle Ltd	Barceolona
100004	Vegiland	Vegi Transport Ltd	Berlin

What I want is to create a view. if I create a Listbox with Customername and choose Johnny Fish Market. It should give me out in a diagram:

Customername	Country	Product	Invoice	Year	Transportagency
Johnny Fish Market	Japan	Salmon	1000	2013	Shipping Ltd
Johnny Fish Market	Japan	Tuna	2000	2014	Shipping Ltd
Johnny Fish Market	Japan	Octopus	1000	2015	Shipping Ltd
Johnny Fish Market	Japan	Seatongue	3000	2016	Shipping Ltd

I know that I have to configure the script and read sth about the Mapping function. I am a beginner andI dont really know how to do it. Could anyone help me here?

I attached an Excel file.

Re: combining 3 different excel sheets

Gysbert_Wassenaar — Mon, 02 Nov 2015 13:00:36 GMT

All you have to do is load the data, create a table box with the fields you want to see and select Johny Fish Market. See attached qvw.

Re: combining 3 different excel sheets

thanhphongle — Mon, 02 Nov 2015 13:06:38 GMT

yeah i figured out, i thought i had to do sth like INNERJOIN like in Access. But could you explain me what the mapping function is. Maybe with an example.

Re: combining 3 different excel sheets

Gysbert_Wassenaar — Mon, 02 Nov 2015 13:09:45 GMT

See this blog post: Don't join - use Applymap instead

topic combining 3 different excel sheets in QlikView

combining 3 different excel sheets

Re: combining 3 different excel sheets

Re: combining 3 different excel sheets

Re: combining 3 different excel sheets