topic Re: Sales from the lead in QlikView

Sales from the lead

lfholland — Wed, 25 Nov 2020 16:16:04 GMT

I need to show "sales from the lead". It's like in golf where they have "strokes from the lead". I tried the above function and several variations, but it isn't giving me what I need. So, below is the sales growth and then next to it, the above formula.

my growth formula is as follows:

sum({<Year={$(=Max(Year))}, VendId={'100423', '100047', '100060'}, Month={'Sep','Oct','Nov','Dec'}, CurPrevYTD={1},Whse_District={'SOUTHWEST'}>} NetSalesDOM)/1000
-
sum({<Year={$(=Max(Year)-1)}, VendId={'100423', '100047', '100060'}, Month={'Sep','Oct','Nov','Dec'}, CurPrevYTD={1},Whse_District={'SOUTHWEST'}>} NetSalesDOM)/1000

The first value ($23) is correct, but the next one should be $93 and the next should be approx. $105 and so forth. It is telling how much the branch needs to sell in order to get up to the leader.

Thanks in advance for your help.

Re: Sales from the lead

YoussefBelloum — Thu, 13 Sep 2018 15:16:31 GMT

Hi,

for the first value 23, it is calculated this way: 75-52

for the next expected values, how it is supposed to be calculated ?

Re: Sales from the lead

lfholland — Thu, 13 Sep 2018 15:20:02 GMT

Yes, the first one is 75-52. The next one should be 75-(-18). Or it could be 23+70. I tried using the above() formula to get the first value and then add the one above it, but that didn't work either...

Re: Sales from the lead

YoussefBelloum — Thu, 13 Sep 2018 16:10:41 GMT

I got it

try this (if you use absolute values for negative values)

=top(sum(your_field))+sum(your_field)

or this if you use your negative values:

=top(sum(your_field))-sum(your_field)

Re: Sales from the lead

lfholland — Thu, 13 Sep 2018 18:08:38 GMT

Thank you! That works!