Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I think you can use Qlik inbuilt functionality for accumulation. you can use full accumulation or custom accumuation.
Best Regards,
Arunesh kumar
Thanks, I am already using the inbuilt functionality or accumulation from Qlik. Therefore I am wondering that it is not working....any ideas?
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.
Perhaps this?
Rangesum(Below(Sum(
{<[YearMonth]={"$(='>=' & MonthStart(yearstart(max(YearMonth))) & '<=' & MonthEnd(Max(YearMonth)))"}>}
Quantity)),
Thanks
What is the purpose of "GetObjectField"?
Thanks, Tom
Thanks, unfortunately not working.