Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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!
Load
project,
[start month[ as [common date],
[start amount]
from table1
concatenate
load
project,
[target month] as [common date]
[target amount]
from table 2;