Combo Chart with accumulation over Year-Month

[TomBond77]

Hi experts

I have this formular with property "Modifier" -> Accumulation, steps = 12.

Sum(
{<[YearMonth]={"$(='>=' & MonthStart(yearstart(max(YearMonth))) & '<=' & MonthEnd(Max(YearMonth)))"}>}
Quantity)

Without setting any value on filter YearMonth I am getting this result in the chart.

When setting a filter, e.g. 2023-Oct the whole line disappears, only a dot is shown. This is the incremental / delta value for 2023-Oct:

Any ideas how to solve this YTD accumulation issue? I would like to see the accumulated value from 2023-Jan to the selected month.

Thank you, tom

[aruneshgupta]

I think you can use Qlik inbuilt functionality for accumulation. you can use full accumulation or custom accumuation. 

Best Regards,

Arunesh kumar

[TomBond77]

Thanks, I am already using the inbuilt functionality or accumulation from Qlik. Therefore I am wondering that it is not working....any ideas?

[aruneshgupta]

Are you using Sum(Quanity) or full expression when adding inbuilt accumulation ? 

I can see this output expression afer adding custom 12 accumualtion. 

RangeSum(Above(If(Count([$(=Replace(GetObjectField(0),']',']]'))]) > 0, (　sum(Quantity)　) + Sum({1<[$(=Replace(GetObjectField(0),']',']]'))]={">=$(=Min([$(=Replace(GetObjectField(0),']',']]'))]))<=$(=Max([$(=Replace(GetObjectField(0),']',']]'))]))"}>}0), 0), 0, 12))

Also makesure YearMonth should be proper date format. 

[Anil_Babu_Samineni]

Perhaps this?

Rangesum(Below(Sum(
{<[YearMonth]={"$(='>=' & MonthStart(yearstart(max(YearMonth))) & '<=' & MonthEnd(Max(YearMonth)))"}>}
Quantity)),0),Above(YearMonth,1,1000))

[TomBond77]

Thanks

What is the purpose of "GetObjectField"?

Thanks, Tom

[TomBond77]

Thanks, unfortunately not working.