How to create common time dimension for data in multiple tables?

[letileti]

Hello all,

someone who can guide me on how to solve the following:

What I have:

table1:  project;start month;start amount

table2: project; target month;target amount

additional info: one project in table 1 can have multiple ‘start months’

What I want to do:

Create a line chart Providing evolution by month of start amount (table 1) and target amount (table 2). 

How do I get one common time dimension for start month and target month?

Looking forward to the solution

[kjhertz]

This looks like a question of "should I link or concatenate", so you need to do some scripting to setup the right data model for your case. See this blog post for an in depth discussion about the alternatives: https://qlikcentral.com/2016/11/24/should-i-link-or-concatenate/

Concatenation or Join (if unique keys) and a link table, as showcased in the blog post, should result in a common time dimension for start month and target month.

Hope this sets you on the right track!

[Michiel_QV_Fan]

Load 

project,

[start month[ as [common date],

[start amount]

from table1

concatenate 

load

project,

[target month] as [common date]

[target amount]

from table 2;

[kjhertz]

Hehe yes better to keep it simple as that 🙂

[Michiel_QV_Fan]