Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Create new scenarios within load editor of qlik sense

Looking for help from this genius body.  I'm trying to create a dimension using a variable that will reference a dimension & month combination but getting nowhere!  The table below is an example.  My model is quite larger than this, but this simple example is the problem.  I want to create a full year scenario called "Cur Fcst" that will pull Actual Jan, Actual Feb, 2+10 Forecast Mar-Dec.  How do I do that???


ScenarioMonthRevenue
PlanJan100
PlanFeb200
PlanMar300
PlanApr400
PlanMay500
PlanJun600
PlanJul700
PlanAug800
PlanSep900
PlanOct1000
PlanNov1100
PlanDec1200
ActualJan150
ActualFeb190
2+10 FcstMar250
2+10 FcstApr275
2+10 FcstMay345
2+10 FcstJun415
2+10 FcstJul485
2+10 FcstAug555
2+10 FcstSep625
2+10 FcstOct695
2+10 FcstNov765
2+10 FcstDec835
0 Replies