Data Aggregation question?

[eghostine]

Kindly find the attached data that I'm working to aggregate on Qlik Sense using straight table.

The excel file includes the raw data and the scenario that i need to manipulate.

i failed to aggregate the data using RangeSum(), Above() and Sum() functions.

Please advise.

[chrismarlow]

Hi,

You could try a valueloop if your Rnumber are fixed, similar to below. Few odd numbers in  your spreadsheet though .. so I can't agree your numbers;

Cheers,

Chris.

[eghostine]

Hi Chrismarlow,

Thanks for your reply.

Actually we have multiple Bname values with different ranges of Rnumber.
That's why i wanted a dynamic aggregation to get the result for multiple Bnames.

My numbers are calculated based on the sum of the cells that you can find in Aggregated table result
as you can see below.

[chrismarlow]

Hi,

I couldn't match the aggregation between your left and middle set of columns, which then makes impossible to agree to the rightmost set. So for B1-3-999 combo I got values totalling 370 (my column L in my screenshot) vs 460 in your calculation, that then impacts the calculation you have highlighted.

You could probably extend the value loop to cover all options but I agree it does feel like something that should be possible with above/rangesum which would probably be more performant if you have lots of data.

Cheers,

Chris.