Plotting two lines on a chart over 12 weeks

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Im really new to Qlikview and im trying to plot two lines on a line chart, one is actual one is budget

I can get one or the other to show but not both at the same time, is it something to do with the expression formula or something I need to do in the properties?

My expressions are

Actual = sum({<$(vSetRolling12Wk),CalendarIsWeekEnd={1}>}
if(OccupancyInHomeFlag = 'Y' or OccupancyAbsentBeingBilledFlag = 'Y', OccupancyGrossRate))
/
count(if(OccupancyInHomeFlag = 'Y' or OccupancyAbsentBeingBilledFlag = 'Y', ResidentCode)) * 7

Budget = Sum({<$(vSetRolling12Wk)
,Category={'AWF Budget'}
,Description={'Average Weekly Fee'}
,Period={'WEEKLY'}>}BudgetValue)

If I cahnge actual to this then it plots actual but not the budget

= sum({<$(vSetRolling12Wk)>}
if(OccupancyInHomeFlag = 'Y' or OccupancyAbsentBeingBilledFlag = 'Y', OccupancyGrossRate))
/
count(if(OccupancyInHomeFlag = 'Y' or OccupancyAbsentBeingBilledFlag = 'Y', ResidentCode)) * 7

topic Plotting two lines on a chart over 12 weeks in QlikView

Plotting two lines on a chart over 12 weeks