fixed value un column

Thu, 02 Jun 2016 15:02:00 GMT

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..

seller	copmany	kg	% of total
seller 1	company 1	100	22%
seller 1	company 2	200	44%
seller 2	company 1	150	33%

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

Re: fixed value un column

sunny_talwar — Thu, 02 Jun 2016 15:28:38 GMT

May be this:

Sum(Quantity)/Sum(TOTAL Quantity)

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

topic fixed value un column in QlikView

fixed value un column

Re: fixed value un column