Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

parks399
New Contributor II

Trying to create a annual view of results by adding field combinations<

I posted this previously with no reply but I know this should be able to work.  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
Community Browser