Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
francisco_cohen
Contributor III
Contributor III

Calculate wheight value

Hi,

I need to add a measure to calculate the wheight of each of my table rows:

CustomerAmountWeight
A50027%
B100054%
C35019%
TOTAL1850100%

 

How can I do this?

Thank you,

FC.

Labels (1)
1 Solution

Accepted Solutions
dilipranjith
Partner
Partner

Use total qualifier
Assuming your Amount Expression is Sum(Amount)
new expression for weight Sum(Amount)/Sum(total Amount)
reference for the total qualifier below
https://community.qlik.com/t5/Qlik-Design-Blog/What-does-the-TOTAL-qualifier-do/ba-p/1472990

View solution in original post

1 Reply
dilipranjith
Partner
Partner

Use total qualifier
Assuming your Amount Expression is Sum(Amount)
new expression for weight Sum(Amount)/Sum(total Amount)
reference for the total qualifier below
https://community.qlik.com/t5/Qlik-Design-Blog/What-does-the-TOTAL-qualifier-do/ba-p/1472990

View solution in original post