cancel
Showing results for
Did you mean:
Contributor III

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

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.

1 Solution

Accepted Solutions
MVP

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)

2 Replies
MVP

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)

Contributor III
Author

It works. Thank you!!!

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