Combo Chart Previous Year and Monthly current Year

[Rehan]

I am using QS Enterprise 06/2019 release. I am working  on a Combo Chart with Months as Dimension and using the 2 expressions as below

Bars- COunt({<[Cal Year]={$(=Max([Cal Year]))}>} Distinct CustomerID)

Line(Cumualative for Current Year) -RangeSum(Above(TOTAL COunt({<[Cal Year]={$(=Max([Cal Year]))}>} Distinct CustomerID), 1, RowNo(TOTAL)))

Please see the attached desired result. I want to show the Bars for current year (Jan-Oct) and a single bar call "Baseline" which will be the total of Previous year (2019) and a Bar for Target.

How I can accomplish this

[dplr-rn]

not sure if this is the best way but i think you may need to use value list . see below url for reference.

https://community.qlik.com/t5/Qlik-Design-Blog/ValueList-For-those-tricky-situations/ba-p/1476275

basically your value list will be (previous year, jan, feb,...dec, total)

[blueran]

https://community.qlik.com/t5/QlikView-Documents/Missing-Manual-ValueLoop-ValueList/ta-p/1481012