Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Linking Targets to Facts

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

1 Solution

Accepted Solutions
Contributor II
Contributor II

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.

View solution in original post

1 Reply
Contributor II
Contributor II

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.

View solution in original post