Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
How to implement intepolation formula in qlikview
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.
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.
And how would you calculate this outside of QlikView?
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
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
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.