topic Re: RangeSum Issue in QlikView

RangeSum Issue

dineshm030 — Wed, 03 Oct 2018 07:41:50 GMT

Hi All,

I am creating the report with RangeSum function. I am facing some issue with that function.

I want in Jun-18 field should be adding with previous two month's value.

Expression:

RangeSum(Before(Sum({<IMSMonthName,IMSYear,DATAPERIOD={">=$(=date(addmonths(date#(max(DATAPERIOD),'YYYYMM'),-2),'YYYYMM'))<=$(=max(DATAPERIOD))"}>}NVALUE)/1000000,0,3))

Thanks in advance.

Re: RangeSum Issue

swuehl — Wed, 03 Oct 2018 07:46:44 GMT

If you want a time range from Apr 18 to Jun 18, you need to select Jun 18 in DATAPERIOD to set the max(DATAPERIOD) accordingly or change your search expression in the set expression accordingly.

Re: RangeSum Issue

dineshm030 — Wed, 03 Oct 2018 07:56:43 GMT

Hi Stefan,

If i will show 12 months the values are correct except Sep-17. i am using the below expression.

In Sep-17, it should be adding Sep,Aug and July value.

Expression:

RangeSum(Before(Sum({<IMSMonthName,IMSYear,DATAPERIOD={">=$(=date(addmonths(date#(max(DATAPERIOD),'YYYYMM'),-11),'YYYYMM'))<=$(=max(DATAPERIOD))"}>}NVALUE)/1000000,0,3))

Re: RangeSum Issue

dineshm030 — Thu, 04 Oct 2018 06:25:30 GMT

Hi All,

Kindly refer the screenshot. I am using rangesum function. I am strugging with that function.

The Issue is in OCT-17 and SEP-17. Kindly help me.

Expression:

RangeSum(Above(Sum({<IMSMonthName,IMSYear,DATAPERIOD={">=$(=date(addmonths(date#(max(DATAPERIOD),'YYYYMM'),-11),'YYYYMM'))<=$(=max(DATAPERIOD))"}>}NVALUE)/1000000,0,3))