Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
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