Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)