QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for
Did you mean:
Partner

Formula Growth in Excel also in QlikView

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?

1 Solution

Accepted Solutions
MVP

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?

2 Replies
MVP

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

MVP

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?

Community Browser