Hi
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