Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Magogar
Contributor II
Contributor II

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)

Magogar_2-1637669015222.png

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

Could you help me, please?

 

 

 

 

1 Solution

Accepted Solutions
Or
Champion
Champion

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)

 

View solution in original post

2 Replies
Or
Champion
Champion

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
Contributor II
Contributor II
Author

It works. Thank you!!!

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