Formula Growth in Excel also in QlikView

[francisvandergr]

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?

[sunny_talwar]

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

[sunny_talwar · Accepted solution]

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?