topic Re: LINEST_B NOT Working in QlikView

LINEST_B NOT Working

christian77 — Tue, 26 Aug 2014 13:20:56 GMT

Hi Qlikers:

I was going to place a resource, my first one, but look what I found.

Linest_b funcktion is not working. I could be doing something wrong that I have not realized.

Can you help me?

Is this a bug?

I've attached an example to leave it clear.

I know that you know that we all know that it is not my intention to give a hard time to QlikTech people. All the opposite: I just want to help you, and help myself by helping my boss who at the same time is helping the client.

It's all about helping.

Thanks.

Re: LINEST_B NOT Working

ashfaq_haseeb — Tue, 26 Aug 2014 13:31:47 GMT

Hi,

What are you trying to achieve here

Regards

ASHFAQ

Re: LINEST_B NOT Working

christian77 — Tue, 26 Aug 2014 13:57:44 GMT

Hi Ashfaq:

Well, I want linest_b to be working. Otherwise I'm going to have to calculate it myself using square sums.

Inside the chart, there are 3 values. One of them does not match. Can you see it? Y=linest_m(X)+linest_b and R2.

linest_b is very different.

I can't place my resource with that funcktion not working.

Only QlikTech can fix it.

Salutes.