Aggregation data in Pivot table

Daniele3 — Tue, 17 Sep 2024 14:44:03 GMT

Hello everyone, I am new to programming with Qlik and I need help with a request that was made to me.

I have a pivot table with data written in a format similar to this:

GROUP | VALUE

210 1000
220 2000
230 3000
310 1000
320 2000

I would like to aggregate the values in the format:

GROUP | VALUE

200 6000
300 3000

And, expanding the data, clicking on the "+", then see the subdivisions in the following way:

GROUP | VALUE

200 6000
- 210 1000
- 220 2000
- 230 3000
300 3000
- 310 1000
- 320 2000

Can anyone suggest a method to do this?
Thanks in advance

Re: Aggregation data in Pivot table

QFabian — Tue, 17 Sep 2024 19:53:58 GMT

Hi @Daniele3 , here an option, creating the additional field in script :

Data:

Load //precedent load

floor(GROUP / 100) * 100 as Level_1;

Load * INLINE [ //your data

GROUP, VALUE

210, 1000

220, 2000

230, 3000

310, 1000

320, 2000

];