topic Re: Formula Growth in Excel also in QlikView in QlikView

Formula Growth in Excel also in QlikView

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

In Excel you have function growth. I like to have this in QlikView. Is this possible.

I attache a simple datamodel and a excel sheet as example.

I like to have values for the periods 6 to 10. Is this possible and how?

Re: Formula Growth in Excel also in QlikView

sunny_talwar — Wed, 18 Sep 2019 15:30:33 GMT

I have never used this function before in Excel, do you happen to know how is growth percentage getting calculated? I am looking online as well, but just thought of asking...

Re: Formula Growth in Excel also in QlikView

sunny_talwar — Wed, 18 Sep 2019 16:48:42 GMT

Try this

If(Len(Trim(Qty)) > 0, Qty, exp((LINEST_M(TOTAL {<Qty = {'*'}>}Log(Qty), Period)*Period)+LINEST_B(TOTAL {<Qty = {'*'}>}Log(Qty), Period)))

Got helped from Math behind Excel's GROWTH function?