Accumulation in Pivot Chart

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I am working on full accumulation in pivot chart by using Rangesum and Above function.

I am using Aggr in expression and Limiting time period by using variable for From date and To date.

By applying Rangesum , I am getting correct Accumulation for desired period, but getting 0 value for before desired time period and Last value remain constant for after time period.

Eg. If I am considering time period from 1st April, 2017 to 15th April 2017, I am getting 0 values for 1st Jan 2014 to 31st March, 2017 and 15 is constant for 15th April, 2017 onward.

Kindly help to remove these 0 Values and these constant values.

Thanks in advance...

My Exp:

if(Dimensionality()=6,

RangeSum(Above(SUM(AGGR(Count({<POSTING_NUM={">=$(vStartDate)<=$(vEndDate)"},TIME_INTERVAL_STATUS={'DELAY'},QV_REPORT = {'Page Release'},DATE-={' '},DATE_TYPE={'Distinct'},

QV_FLAG={'Time'}>} DISTINCT POSTING_NUM),STATE,PLANT,EDITION_DESCPRTION,

CALENDER_PROD_DATE,QV_REPORT)),0,RowNo())),

SUM(AGGR(Count({<POSTING_NUM={">=$(vStartDate)<=$(vEndDate)"},TIME_INTERVAL_STATUS={'DELAY'},QV_REPORT = {'Page Release'},DATE-={' '},DATE_TYPE={'Distinct'},

QV_FLAG={'Time'}>} DISTINCT POSTING_NUM),STATE,PLANT,EDITION_DESCPRTION,

CALENDER_PROD_DATE,QV_REPORT))

)

topic Accumulation in Pivot Chart in QlikView

Accumulation in Pivot Chart