Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Linest_M brings different results when loaded Inline or with qvd

After trying to find the source of this error for some hours now i decided to ask you guys.

Im trying to calc b1 and b0 (through y=0) for a regression (slr).

After calculating the values I compared them to the output of a statistical software and they where different.

Then I loaded the table Inline and the results where correct.

I tried both to calc the b1 ; b0 in the script and in a diagramm. There was no difference.

I really dont know why it is like this.

Pls find attached the qvw and qvd. just change the path to qvd in the script to test it.

Cheers & thx in advance

//chesterluck

1 Solution

Accepted Solutions
Gysbert_Wassenaar

It has to do with the load order of the values. If you sort the data from the qvd by Menge you get the same results as from the inline load. This is related to the third parameter you used in the linest_m function.


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

It has to do with the load order of the values. If you sort the data from the qvd by Menge you get the same results as from the inline load. This is related to the third parameter you used in the linest_m function.


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

super - that the mistake. It tried to order by before but failed due to trying order by on a qvd which is impossible.

thank you ver much

greetings chesterluck