Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Aggr Sum - problem

Hi all,

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:


Part numberOrder
A50
B100
C25
D50
E75


2. Tabel with parts in groups:


GroupPart number
IA
IC
IIB
IID
IIIE



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:

GroupPart numbershare in %
IA33%
IC66%
IIB66%
IID33%
IIIE100%


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


Mateusz