Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mariaogic
New Contributor

Comparing Budget vs Actual result

I would like your help with this, I am trying to create a dashboard comparing budget with sales for specific users.

I do not know how to create the data model to do this correctly without creating cirkular references. Below is a picture of that part of the data model, what I would like to do is to associate the date fields in Budget and Sale.

Since I need to associate the tables on aassociate_id, I can't associate the date fields, because that causes a cirkular reference.

Does anyone know how to solve this?

Datamodel.JPG

1 Solution

Accepted Solutions
agigliotti
Honored Contributor II

Re: Comparing Budget vs Actual result

you can create a unique FACT table concatenating both tables (Budget and SALE).

like below:

FACT:

load *, 'SALE' as source From SALE

CONCATENATE

load *, 'BUDGET' as source From Budget

4 Replies
agigliotti
Honored Contributor II

Re: Comparing Budget vs Actual result

you can create a unique FACT table concatenating both tables (Budget and SALE).

like below:

FACT:

load *, 'SALE' as source From SALE

CONCATENATE

load *, 'BUDGET' as source From Budget

Re: Comparing Budget vs Actual result

Maria

Concatenating seperate Fact tables into a single fact table as Andrea suggests is a powerful and good thing.  Well worth giving it a go and adding it to your repertoire of good things you know about.

mariaogic
New Contributor

Re: Comparing Budget vs Actual result

Thank you!

oknotsen
Honored Contributor III

Re: Comparing Budget vs Actual result

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post; not visible in preview) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .

May you live in interesting times!
Community Browser