Linking Targets to Facts

fescudero — Fri, 09 Sep 2016 13:40:55 GMT

Hi,

I am struggling to create a good data model to use Set Analysis and calculate the right expressions. Hopefully you can help.

Basically I have the following data model:

Facts Table:

Date

, Business Unit

, Channel

...

, Many other fields

...

Master Calendar:

Date,

...

, standard calendar fields

...

Targets:

Date

, t_Business Unit (identical values to Business Unit in Facts Table)

, t_Channel (identical values to Channel in Facts Table)

, t_Measure_1

And then I try to create some graphs with expressions:

= sum({$<t_BusinessUnit= P(BusinessUnit),t_Channel= P(Channel)>}t_Measure_1)

That works fine, but if I try to use a graph/table with a Channel or Business Unit dimension, the expression is not working as I thought.

Should I change the data model and create an unique Fact Table with the Facts and the Targets?

Now they are linking with the date. Should I create a table in the middle with Business Unit and Channel or link them with the autonumber function instead?

Any suggestion would be much appreciated.

Thanks

Re: Linking Targets to Facts

fescudero — Mon, 12 Sep 2016 12:57:41 GMT

Hi again,

If instead of having Facts and Targets linked to a Master Calendar as separated tables, I just concatenate them in an unique table (as they share several attributes) then is working fine.

I would like to know, anyways, if there is other way to do it.

Hopefully you have some other ideas.

Thanks a lot.

topic Linking Targets to Facts in QlikView

Linking Targets to Facts

Re: Linking Targets to Facts