topic a waterfall question in QlikView

a waterfall question

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

hi friends,

need some help here on one of the waterfall request as attachment.

1.to calculate DDLT quantity(sum of forecast qty highlighted in green one) based on LT + 1. eg. if LT = 10, sum 10+1 forecast quantity column to get the DDLT quantity

2.to get previous DDLT. is this Peek('DDLT')?

thank you and have a nice day.

Re: a waterfall question

ogautier62 — Fri, 13 Jul 2018 06:38:15 GMT

Hi,

in a graph use : above to get previous (line above) :

example :

Prev DDLT = above(DDLT)

regards

Re: a waterfall question

Anonymous — Fri, 13 Jul 2018 07:04:51 GMT

hi Olivier,

thanks for the response.

any suggestion how to come out the formula for the 1st item?

DDLT quantity(sum of forecast qty highlighted in green one) based on LT + 1.

eg. if LT = 10, DDLT quantity= sum total of 10+1 forecast quantity column

if LT = 12, DDLT quantity= sum total of 12+1 forecast quantity column

the key is CPN+region+Fcst Crtd Date.

thanks.

Re: a waterfall question

ogautier62 — Mon, 16 Jul 2018 07:02:56 GMT

OK,

so use expression :

RangeSum(Above(sum(quantity),0,LT+1))