Mastering Set-Expression

[Enno86]

Hi Qlik-Experts,

I want to generate a grid chart using two dimensions and calculate the relative fraction but aggregated by one of the dimension.

Unforturnately I am struggling right now.

Attached screenshot shows, that the sum per each row seems to work.

The overall "aggregated sum" is also correct (2.540.234), but for my understanding it would need to be shown in each row of the last column.

Could you please help to push me in the right direction?

Thanks in advande

[marcus_sommer · Accepted solution]

Try it with: sum(TOTAL aggr(sum()))

[Enno86]

Thanks @marcus_sommer . Works as intended 🙂

What would I need to add to have it totalling the sum for each of my groups seperately in the first column?

can this been done with an alteration of the formula or only with something like "rangeabove"?

[Enno86]

I was able to find this within the community, which helped me getting forward: https://community.qlik.com/t5/QlikView-App-Dev/set-analysis-total-by-dimension/m-p/1209362/highlight...