Qlik Community

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 
Search instead for 
Did you mean: 
francisvandergr
Partner
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
sunny_talwar

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? 

View solution in original post

2 Replies
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

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?