Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 | Region | 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!
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?
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?
Yup a couple of resident Crosstable loads.
This explains Crosstable table loads.
http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/24/crosstable
Regards