data association question

[#1]

Hello, respected experts,

I am a new Qlik sense enterprise user but played with desktop version for a while.

I have a problem with data association (at least i think it is all about data association)

I have uploaded 3 files from database, sales, booking and backlog, which all have date, product type, region, industry sector and customer name fields. currently I associate them together with a separate calendar file with YearMonth fields. so I created a  filter with "Year Quarter Month" to show the total depending on the time period selected. so far so good.

I also need to create  filters to look at region, product Type or IndustrySector for all three files, which I ran into problems.

if I use sales.productType as dimension for filter, I can't filter other two files; if I associate all three files with ProductType, then I can filter ProductType for 3 files w/o problem, but I can't select time period of all 3 files.  I understand it is not recommended to have more than one association (causing synthetic key), but how do I approach this?

also, I want to create the table as below for the select time period, only sales show the correct distribution among the industrySector, orders and backlog only populated as total values;

sales.INDUSTRYSCTOR	sales	orders	backlog
INDUSTRIAL
ENERGY
SPACE
GOVT/DEFENSE

can I create a dimension which can apply to all 3 files, and used in table and filter? 

can creating a compound key to associate all 3 files solve the problem? how the compound key would look like in this case?

Please forgive the question is too basic, got stuck.

I am looking forward to reading here for solutions,

Lei

Message was edited by: Lei Zhou I created a sample file mirroring the real data. Thanks all the community experts, please shed me some lights on my problems, I want to have this solved. THANKS!!!

[ahaahaaha]

Hi Lei,

You can see a fragment of your original data? Ideally, downloaded Qlik Sense.

Regards,

Andrey

[mdmukramali]

Dear Lei,

if you have multiple dimension fields common  between the tables you can use Link Table concept to affect the selection on all the fields.

can you share the sample application so that we can help you in better way,

Thanks,

Mukram

[#4 · Accepted solution]

thank you very much for both of you. I will generate  sample data sets and Qlik  application and upload. thanks.

[#5]

Hi

I think you should take a look at concatenate and best practices of creating data models in Qlik. It's not as in a database.

Understanding Join, Keep and Concatenate

https://help.qlik.com/en-US/sense/3.1/Subsystems/Hub/Content/LoadData/concatenate-tables.htm

Best Practices for Data Modelling

[#6]

how do I upload a qvf file here? Thanks.