Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
ArildR
Contributor
Contributor

Comparing two tables (budget and actuals) with multiple dimensions

Hello,


I have 2 tables that I want to compare using qlik sense. 

1: Budget with dimensions like: Account, Country, Cost Center, Date - and amount. (this table consist of actual transactions and invoices that all includes the columns. 

2: Budget: Account, Country, Cost Center, Date - and amount. 

I have tried importing the two tables to qlik sense but cant get the dimensions to match up.  I can choose witch column that will be the key connecting the tables - but it wont let me choose mulitple dimensions as key. 

So in my report I cannot compare budget to actual on more then one dimension at time. 

ArildR_0-1591725541590.png

On the picture I can choose witch column that should be mutual - but not them all at once. 

How is this supposed to be done?

 

 

Labels (1)
1 Solution

Accepted Solutions
Vegar
Partner
Partner

By the looks of what you have shared with us I would probably considered concatenated the two tables into one single transaction table. Like this. 

TRANSACTIONS:

Load

Account,

Country,

Cost Center,

Date,

Actual_amount

From Actuals;

CONCATENATE (TRANSACTIONS) 

Load

Account,

Country,

Cost Center,

Date,

Budget_amount

From Budget;

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

2 Replies
Vegar
Partner
Partner

By the looks of what you have shared with us I would probably considered concatenated the two tables into one single transaction table. Like this. 

TRANSACTIONS:

Load

Account,

Country,

Cost Center,

Date,

Actual_amount

From Actuals;

CONCATENATE (TRANSACTIONS) 

Load

Account,

Country,

Cost Center,

Date,

Budget_amount

From Budget;

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

ArildR
Contributor
Contributor
Author

Yes - Many thanks.

Your Swenglish was perfect for my Norweglish understanding and it worked,

 

😁