Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
vadim_grab
Creator
Creator
‎2017-09-18 03:35 PM

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



550 Views
0 Likes
0 Replies