IYA for Month in Pivot Table. RangeSum()

vadim_grab — Mon, 18 Sep 2017 19:35:57 GMT

Hi, All

I have a problem that is calculate IYA (index year ago) Vol in next chart for each month in chart

So, not long thinking decided to use RangeSum()

IYA=RangeSum(Month2017)/RangeSum(SameMonth2016)

RangeSum for Months 2017:

RangeSum(After(Sum({< $(vSetYTD)>Vol),0,$(=Max(PeriodID) -60))) work right with result in line 2017

RangeSum for Months 2016:

RangeSum(After(Sum({< $(vSetLYTD)>Vol),0,$(=Max(PeriodID) -48))) work not right with result in line 2016 (Total 48 908).

Everything went well until Month = 'авг' from this month RangeSum will reflect incorrect result - 48 908 that which began to repeat from month to month until the end of the year.

It's QV bug? Whats wrong with my code?

Many thanks to everyone who cares about other people's issues!

Vadim

topic IYA for Month in Pivot Table. RangeSum() in QlikView

IYA for Month in Pivot Table. RangeSum()