Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

How to repeat 2 columns in two tables w/o syn key

I am creating a report that combines two data type:

- an analysis of how many shipments were sent 

- an analysis of how many employees needed to work during this time

both tables have the column Date and City, and I'd like to make such filters that if I choose the city Berlin, all the shipments and employees related to Zurich will be displayed.

Unfortunately, when I leave those two columns in two tables the synthetic key appears.

Does someone have a work around this problem?

 

3 Replies
Highlighted
Specialist
Specialist

You can concatenate the tables.

That way, if you make selections in either Date or City, the data will follow the selections (for both tables, or well, the concatenated table)

Highlighted
Specialist III
Specialist III

Highlighted
Contributor
Contributor

Quick fix is to rename the fields in 1 table, or move the columns from both tables into a new table and link to these with a unique key.  These quick fix suggestions are probably not the proper answer but will get rid of the synth key.

You need to review the context of your fields used for say country i.e. ship vs employment country, etc.  and see how that should really fit in on your data model.  

Actually the concat suggestion above is probably a nicer quick fix