Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
TDQlik
Contributor II
Contributor II

Comparing Budget to Expense

Hi,

I have an Expenses table that has the following fields:

Year, Quarter, Framework, Topic, Subject and Expense Amount

A framework has different Topics, a Topic has different Subjects.

Then I have my budget table with the exact same fields except it has "Budget Amount" instead of Expense amount.

Now I've read to concatenate them but unfortunately concatenating them (at least in data manager) leaves the budget amount field empty with nulls. When I associate them as separate tables on the lowest level "Subject" the budget obviously appears on each row if I have that subject appearing 5 times the budget amount appears 5 times. 

How can I approach this? I would like to compare expense vs budget on all 3 levels, for Framework, Topic and Subject without the data being aggregated. Something through a dimension link table? Is it granularity, cardinality? 

Thanks in advance!

0 Replies