Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
vadim_grab
Contributor

IYA for Month in Pivot Table. RangeSum()

Hi, All


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


chart1.png

chart2.png


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