Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
danschofield1
New Contributor

Plotting two lines on a chart over 12 weeks

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