Simplified expression for rangesum set analysis ( 10yrs data accumulation)

riceball — Thu, 13 Jun 2019 09:18:49 GMT

Hi,

I'm facing some problem with following script ( Please see attached sample as well). Basically, I would like to accumulate 10 years of Qty based on my dimension year. I wonder if there is any simplified and dynamic scripting so that i do not have to hardcode every year from 2019 onwards.

Greatly appreciate your help on this!

Expression:

=IF(CalendarYear='2019',
Sum({$<CalendarYear={">=2009<2019"}>} Total Qty),

IF(CalendarYear='2020',
Sum({$<CalendarYear={">=2010<2020"}>} Total Qty),

IF(CalendarYear='2021',
Sum({$<CalendarYear={">=2011<2021"}>} Total Qty),

Rangesum(Above(SUM(Qty),1,rowno())))))

Re: Simplified expression for rangesum set analysis ( 10yrs data accumulation)

rubenmarin — Thu, 13 Jun 2019 10:14:43 GMT

Hi, have you tried?: Rangesum(Above(SUM(Qty),1,10))

Re: Simplified expression for rangesum set analysis ( 10yrs data accumulation)

riceball — Fri, 14 Jun 2019 01:24:22 GMT

Yes, it works! Thank you so much!

topic Re: Simplified expression for rangesum set analysis ( 10yrs data accumulation) in QlikView

Simplified expression for rangesum set analysis ( 10yrs data accumulation)

Re: Simplified expression for rangesum set analysis ( 10yrs data accumulation)

Re: Simplified expression for rangesum set analysis ( 10yrs data accumulation)