topic Re: Connect two tables in QlikView

Connect two tables

Tue, 22 Jul 2014 14:52:19 GMT

Hi everybody,

well, i'm writing here in order to find out how i can create a

connection bw two tables.

I have a table with that columns:

Name of Project	Sales in euro 2014	Sales in euro 2015	Sales in euro 2016	volume for year 2014	volume for year 2015	volume for year 2016
1	10	45	70	1	4	6
2		1010	1
3
4

I would a dashboard where i could select the year from a form (which contains the year: 2014, 2015, 2016...), and after i selected it, i want to see all the data of the analysis.

IE: I SELECT 2015 in a form and after that i should see : sales and volume of 2015.

I think is too easy for u. It's for these reason i worte here then!

Re: Connect two tables

datanibbler — Tue, 22 Jul 2014 14:56:45 GMT

Hi xdedix88,

you will need to do several RESIDENT LOADs - look that up in the help_file, it isn't hard - to ultimately have three dimension fields:

- Name_of_project

- Year

- Region

and two data_fields:

- Sales

- Volume

<=> but - what about the second table? You write that there are two tables that you want to connect?

Re: Connect two tables

Tue, 22 Jul 2014 15:05:33 GMT

well, thanks for the answer.

Actually i have that table i mentioned above and another table coming from a different xls file contains just the year.

sth like that (only one col):

year

2014

2015

2016

2017;

no other infomrations.

how i can connect two tables with different field and no commons keys?

Re: Re: Connect two tables

Anonymous — Tue, 22 Jul 2014 15:06:23 GMT

Yup a couple of resident Crosstable loads.

This explains Crosstable table loads.

http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/24/crosstable

Re: Connect two tables

Anonymous — Tue, 22 Jul 2014 21:22:34 GMT

Regards

Re: Connect two tables

Wed, 23 Jul 2014 13:58:20 GMT

hola Erik

que pasa?

could u help me with that file?Connect two tables