topic Re: Data Aggregation question? in Search the Community

Data Aggregation question?

eghostine — Tue, 14 Dec 2021 13:59:36 GMT

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.

Re: Data Aggregation question?

chrismarlow — Mon, 13 Dec 2021 17:21:33 GMT

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.

Re: Data Aggregation question?

eghostine — Tue, 14 Dec 2021 07:58:38 GMT

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.

Re: Data Aggregation question?

chrismarlow — Tue, 14 Dec 2021 09:35:27 GMT

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.