Obtain the total number ofu nities of a selection to obtain a percentage

[Magogar]

Hi! I have a problem i've been trying to find a solution on.

To get the weight/percentage of certain products, I need to get the total of units in each record, in order to obtain the percentage.

With the function TOTAL:

Sum ({<[Products]={Screws,'Cables','Hammers’,’Nails’}>} TOTAL units)

The problem is that Qlik shows the total amount of units  for all months.

Could you help me, please?

[Or · Accepted solution]

Using the TOTAL qualifier will TOTAL ignoring all dimensions. You can use Total <Field> if you'd like to total within a context instead, e.g. Sum ({<[Products]={Screws,'Cables','Hammers’,’Nails’}>} TOTAL <Month> units)

[Magogar]

It works. Thank you!!!

I just discover that also works with aggr(nodistinct Sum..., but I think your method is better.