Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi @Daniele3 , here an option, creating the additional field in script :