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