Range sum intervals

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

Hi Community,

I want to calculate sum of values based on range of id values rolling back on each number. These range of bucket is coming from other table. and for each row there would be 3 buckets which we need to roll back and do sum. Please understand the sheet1, sheet2 input data.

Start1,End1; Start2,End2; Start3,End3 fields are the intervals that we need to do sum from other table based on range of values.

Here i am attaching input data (excel). and my qlik working file.

Refer output sheet in excel file for my desired output.

Thanks in Advance,

Re: Range sum intervals

sunny_talwar — Thu, 09 Aug 2018 11:41:57 GMT

May be try this

If(Bucket= '0-4',

Sum(If(Date >= Start1 and Date <= End1, Amount)),

If(Bucket= '06-16',

Sum(If(Date >= Start2 and Date <= End2, Amount)),

If(Bucket='17-28',

Sum(If(Date >= Start3 and Date <= End3, Amount))

)))

topic Range sum intervals in QlikView

Range sum intervals

Re: Range sum intervals