topic Re: Interpolation formula in QlikView

Interpolation formula

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

How to implement intepolation formula in qlikview

Re: Interpolation formula

ramasaisaksoft — Tue, 31 May 2016 12:36:37 GMT

Hi Hari,

May i know what out put u required?

Can u give sample input and expected output on that data so that we will help to you properly.

Re: Interpolation formula

Tue, 31 May 2016 13:13:41 GMT

Sales year

1000 1002

1500 998

Above table having for year 1002 i have sales is 1000

And for 998, i have 1500

I need sales for year 1000.

Re: Interpolation formula

sunny_talwar — Tue, 31 May 2016 15:44:36 GMT

And how would you calculate this outside of QlikView?

Re: Interpolation formula

Tue, 31 May 2016 16:01:03 GMT

Hi sunny,

In above example

1500+(1000-998)*((1000-1500)/(1002-998))

In qlikviw need to use bellow formula

: (((Y2-Y1)/(X2-X1)*(X-X1))+Y1

Here X is our selected date

X1 is prev date

X2 is next date

Y1 is prev sales

Y2 is next sales

Above is interpolation formula

Re: Interpolation formula

MarcoWedel — Tue, 31 May 2016 19:41:37 GMT

Hi,

I guess you don't have to implement this expression manually but you can use the functions Linest_M and Linest_B for your requirement:

hope this helps

regards

Marco

Re: Interpolation formula

Thu, 02 Jun 2016 11:13:40 GMT

Hi Marcro Wedel,

Thank you for spending time for me.

I didn't get the correct output. I sharing some sample data, can you please how to implement this. using interpolation formula.

id sales year

10 0.000000512502 1000.48

7 0.00000014555170041714 1000.33

9 0.000005599950 994.77

8 :

22 0.0000000234178405434600 500.47

20 0.0000040797644 499.46

expected output is

year sales

1000 2381

500 1813

Formula:

Sales=Sales1+(year-year1)*(sales2-sales1)/(year2-year1)

where year is expected output year like 1000,500....

year1 is below expected year, year2 is above expected year

same for sales.

Thanks.