Comparing two tables (budget and actuals) with multiple dimensions
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.
On the picture I can choose witch column that should be mutual - but not them all at once.