Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
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
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
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;
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