topic Re: interpolation in QlikView

interpolation

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

any one help on this, I was not able to solve this.

please find the attached document for reference.

Interpolation formula:

Y=Y1+(X-X1)*(YE-Y1)/(X2-X1).

find out the Y value from given points(X1,Y1) AND (X2,Y2) for particular Value X.

X is like 1000,500,200 like this.

I clearly mention the manual calculations and sample data in the attachment. and mentioned expected output.

THANKS.

Re: interpolation

swuehl — Fri, 03 Jun 2016 10:14:15 GMT

Maybe like attached?

Re: interpolation

Fri, 03 Jun 2016 10:20:27 GMT

Yes Swuehl,

The attachment have data , formula and manual calculations.

Thanks

Re: interpolation

swuehl — Fri, 03 Jun 2016 10:36:54 GMT

No, I am talking about the QVW I've attached to my previous post.

Open the full thread in browser (not viewing from within the forum inbox) to see attachments.

Re: interpolation

Fri, 03 Jun 2016 11:30:11 GMT

Not getting correct result by using given expression.

Re: interpolation

Fri, 03 Jun 2016 11:35:31 GMT

Plz implent using given document. I put expected result in the document..

Thanks in advance.

I implent according to your post but i didn't achieve my goal.

Re: interpolation

swuehl — Fri, 03 Jun 2016 11:35:43 GMT

Can you give an example for a given x ?

edit: And also elaborate the context in which you need to get the interpolated values.

Re: interpolation

swuehl — Fri, 03 Jun 2016 12:06:05 GMT

Still missing a more detailed description of the context (script? chart? Based on input table? user input?) you want to use the interpolation.

Attached another version with a script based interval match.

Re: interpolation

Fri, 03 Jun 2016 12:17:31 GMT

Hi swuehl,

Thanks for your reply.

I have one table in given attachment. I need to implement interpolate value for year like 1000, 500, 250, 100, 50.

Not posible to share the script.

My requirement is in a given doc i have a year and corresponding sales. For particular 1000 need interpolate sales value. This value falls between 100.3346 and 994.767670.