Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
vadim_grab
Creator
Creator

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



0 Replies