topic Re: Showing Correlation Coefficient in Chart in QlikView

Showing Correlation Coefficient in Chart

Tue, 28 Jan 2014 08:17:35 GMT

Hi Folks,

Is it possible to create a chart like shows in the attachment?

In the image i have two fields for "Poly GPA" & "CIA GPA" and on that basis I have to calculate Correlation Coefficient (R2) which is shown in line.

Regards,

Yojas

Re: Showing Correlation Coefficient in Chart

tresB — Tue, 28 Jan 2014 08:24:13 GMT

Have a look at Correl() function.

Re: Showing Correlation Coefficient in Chart

Tue, 28 Jan 2014 08:35:28 GMT

Hi,

You can use correl() function. From Qlikview Help:

correl ([{set_expression}] [ total [<fld {,fld}>] ] x-expression, y-expression )

returns the aggregated correlation coefficient for a series of coordinates represented by paired numbers in x-expression and y-expression iterated over the chart dimension(s). Text values, null values and missing values in any or both pieces of a data-pair will result in the entire data-pair to be disregarded. See also the rangecorrel function.

X-expression and y-expression must not contain aggregation functions, unless these inner aggregations contain the total qualifier. For more advanced nested aggregations, please use the aggr function in combination with calculated dimensions.

This function has the same limitations for nested aggregation as the avg function. The correl function supports sets and the total qualifier in the same way as the avgfunction.

Examples:

correl( Payments, Dates )

Re: Re: Showing Correlation Coefficient in Chart

Tue, 28 Jan 2014 09:04:47 GMT

Hi Shyamal,

Thanks for the explanation..

Currently I created 1 sample and in that I am using

"Correl(Aggr(sum([CIA GPA]),[CIA GPA]),Aggr(sum([Poly GPA]),[Poly GPA]))" this expression and getting output on the basis of that. But still i am getting Y not 'y2' .

PFA for my sample.

Kindly suggest if it is the right way..

Regards,

Yojas

Re: Showing Correlation Coefficient in Chart

Tue, 28 Jan 2014 09:24:51 GMT

Might be you need to use "Total" qualifier. Have you tried with Total?

Re: Re: Showing Correlation Coefficient in Chart

Tue, 28 Jan 2014 09:35:26 GMT

Hi Shyamal,

I am getting your point..

Can you provide it in the Sample??

Regards,

Yojas

Re: Showing Correlation Coefficient in Chart

Fri, 26 Sep 2014 17:24:23 GMT

Hi, yojas, im wondering if u still want an anwser for this problem, in that case take a look to the QVW that i made and tell me if that is what u wanted from the begining.

regards.

Re: Showing Correlation Coefficient in Chart

Rina — Sun, 19 Apr 2020 03:36:31 GMT

Hi,

Is Correl() function base on Pearson's ? Or something esle ?

Regards,

Rina