i'm new in a Qlik Sense Community and I have one small problem with Qlik and function AGGR.
I try to show it on short example:
1. Tabel with parts order:
2. Tabel with parts in groups:
The case is, I'd like to say that part "A" is 66% of whole orders in group I and part "C" is 33% (for "A" 50/75 and for "C" 25/75)
The new table could look like below:
|Group||Part number||share in %|
I'v try to solve it with function AGGR and SUM, but it didn't work. Maybe is another way or one of you had once problem like that?
Aggr(Sum(Order), Part number)/Aggr(Aggr(Sum(Order), Group)
Thank you guys a lot and I'm sorry 4 my English