Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

yjyong91
New Contributor

Selecting similar column from 2 different sheets

I have 2 similar columns from 2 different data sheets in Qlik Sense.

Combined.xlsx ! Sheet1

Capture.JPG

Combined.xlsx ! Sheet2

Capture.JPG

Is there anything I can put into the expression of my dimension field so whenever I click either Brani/Keppel in my table, both Brani/Keppel is selected from the 2 sheets.

Capture.JPG

The images attached should be self-explanatory. Thank you!

3 Replies
MVP
MVP

Re: Selecting similar column from 2 different sheets

The Quick-and-Dirty answer:

You should adjust your data model by making sure that the field named Sheet1.Terminal get the name Terminal so it is connected as a key field to the field on Sheet2.

If there are any other fields in the two tables that have same names this will create a problem. But it might work as a quick fix if not.

The better approach:

Create a good data model where the two or more tables have the right keys in between them. In most cases this is done best by creating a dimensional model often called a star schema.

A star schema has a central facts table with measures/metrics and dimension tables describing the metrics.

I can only guess how it should be in your case but it seems to me that you have data for shipping terminals and might want to track some goods between the terminals.

So a dimensional model might look like this:

2018-07-18 21_51_47-Microsoft Edge.png

It might be that you need two date dimensions (tables) instead of one. So this is just an indication of where to start with a simple data model...

DavidŠtorek
Contributor III

Re: Selecting similar column from 2 different sheets

Hi, what is difference between two sheets in your source data?

sunilkumarqv
Valued Contributor II

Re: Selecting similar column from 2 different sheets

Hi ,

Please build data model using data source

to make association between sheets .

Community Browser