topic Re: Correlations - PyTools.Pearson in Integration, Extension & APIs

Correlations - PyTools.Pearson

peterkumar — Sat, 16 Nov 2024 03:32:08 GMT

Hello -

I am new to Qlik Python SSE and am very excited that I can do a time series forecasting with Facebook Prophet.

Now I am trying to do Correlations - similar to 'PyTools.Pearson('10;12;14', '1;2;3').

My question is - what chart do I use for it? A Scatter Plot? but that needs to measures and one dimension. I am trying to use a 'Text & Image' chart - but get no output.

Please suggest.

Thanks!!

Re: Correlations - PyTools.Pearson

anushree1 — Mon, 20 Jan 2020 08:23:33 GMT

Plz chk the attched , Also the KPI Chart Must appear not sure what the issue is here.

In the attchment I have created a Dummy Dimension Valuelist('Value'), I suppose it must be ok as it does not show up in the chart

Re: Correlations - PyTools.Pearson

peterkumar — Mon, 20 Jan 2020 18:57:42 GMT

Thanks Anushree!

Using a KPI worked. Since I am currently experimenting, the following code worked fine - =PyTools.Correlation('10;12;14','200;20;2', 'kendall')

You have some interesting code in your file - just curious - what are the Transactions and Test tables supposed to do?

Thanks again!!

Transactions:
Load
TransLineID,
TransID,
mod(TransID,26)+1 as Num,
Pick(Ceil(3*Rand1),'A','B','C') as Dim1,
Pick(Ceil(6*Rand1),'a','b','c','d','e','f') as Dim2,
Pick(Ceil(3*Rand()),'X','Y','Z') as Dim3,
Round(1000*Rand()*Rand()*Rand1) as Expression1,
Round( 10*Rand()*Rand()*Rand1) as Expression2,
Round(Rand()*Rand1,0.00001) as Expression3;
Load
Rand() as Rand1,
IterNo() as TransLineID,
RecNo() as TransID
Autogenerate 1000
While Rand()<=0.5 or IterNo()=1;

Comment Field Dim1 With "This is a field comment";

Test:
LOAD @1 as Metric,
RowNo() as Rownum
Resident Transactions;

Re: Correlations - PyTools.Pearson

anushree1 — Thu, 23 Jan 2020 06:34:55 GMT

Test table is something I was trying so there is nothing on it .

Rest of the code is the auto generated code which appears when you click on CTRL+0+0 on Edit script window