Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

fixed value un column

Hello

I've been trying to solve this the whole morning but i wasnt able to do it. Here is my problem

The thing is that i have a table with a lot of seller and the amount of kg(pounds) that they sell. In first image above i have one seller with his sales and in the second i have the whole sales of the region. What i want is to divide every single row of a seller into the the sale of the whole region. For example what i want is to divide 159/9395 and 80/9395, etc..

1.PNG

2.PNG

sellercopmanykg% of total
seller 1company 110022%
seller 1company 220044%
seller 2company 115033%

this would be for the first row 100/450 = 22%

and what i want is to put those 450 as a fixed value, note that those 450 are the sum of the entire region and tomorrow migth be 500 and after tomorrow 600 so this has to be a dinamic value as well.

Thanks in advance

1 Reply
sunny_talwar

May be this:

Sum(Quantity)/Sum(TOTAL Quantity)

or

Sum(Quantity)/Sum(TOTAL {1} Quantity)