Discussion Board for collaboration on QlikView Scripting.
someone who can help me achieving this result?
many Thanks for looking into it
i would like to have the breakdown at lower levels (project) too, but ignored it to simplify
Go to Solution.
What you need here is to use a Canonical Date here
Simplified version of the script for the simplified data you provided
Month(Date#(Launch_Month, 'MMM')) as Launch_Month,
Month(Date#(Target_Month, 'MMM')) as Target_Month,
LOAD * INLINE [
Project, Launch_Month, Launch_Amount, Target_Month, Target_Amount
1, Jan, 100, Feb, 200
2, Jan, 20, Jan, 50
Launch_Month as Month,
'Launch' as DateType
Target_Month as Month,
'Target' as DateType