https://community.qlik.com/t5/Connectivity-Data-Prep/Databricks-MLFlow/m-p/2046708#M12127 <P><SPAN>Hi Folks,</SPAN></P> <P><SPAN>I am trying to connect to databricks ML endpoints using Qlik expression editor, I created KPI Object in the sheet and wrote the above expression as per the article below:</SPAN><BR /><SPAN><A href="https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/LoadData/ac-databricks-mlflow-use.htm" target="_blank" rel="noopener">https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/LoadData/ac-databricks-mlflow-use.htm</A></SPAN><BR /><BR /><SPAN>but, in the article example is given only for sum and Aggr. what I am trying to achieve is whatever Prediction value is working out from data load editor should also work from the Qlik expression editor.</SPAN></P> <P>KPI expression is as below:</P> <P><SPAN>=AGGR(endpoints.ScriptEval('{"RequestType":"endpoint", "endpoint":{"connectionname":"Databricks_MLFlow_1.30_2Fields"}}',</SPAN><BR /><SPAN>TAG_LENGTH_MM,COUNTRY),ASP)</SPAN></P> <P>&nbsp;</P> <P><SPAN>Please note the databricks MLflow connection is working fine from data load editor. the above expression is not working.</SPAN></P> <P><SPAN>Kindly help.</SPAN></P> <P>&nbsp;</P> <P><SPAN>thank you.<BR />Sandeep</SPAN></P> <P><BR /><BR /><SPAN>requesting your guidance to achieve this as I am not getting correct values in EXPRESSION editor</SPAN></P> Wed, 08 Mar 2023 11:03:28 GMT sandeepk218 2023-03-08T11:03:28Z https://community.qlik.com/t5/Connectivity-Data-Prep/Databricks-MLFlow/m-p/2046708#M12127 <P><SPAN>Hi Folks,</SPAN></P> <P><SPAN>I am trying to connect to databricks ML endpoints using Qlik expression editor, I created KPI Object in the sheet and wrote the above expression as per the article below:</SPAN><BR /><SPAN><A href="https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/LoadData/ac-databricks-mlflow-use.htm" target="_blank" rel="noopener">https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/LoadData/ac-databricks-mlflow-use.htm</A></SPAN><BR /><BR /><SPAN>but, in the article example is given only for sum and Aggr. what I am trying to achieve is whatever Prediction value is working out from data load editor should also work from the Qlik expression editor.</SPAN></P> <P>KPI expression is as below:</P> <P><SPAN>=AGGR(endpoints.ScriptEval('{"RequestType":"endpoint", "endpoint":{"connectionname":"Databricks_MLFlow_1.30_2Fields"}}',</SPAN><BR /><SPAN>TAG_LENGTH_MM,COUNTRY),ASP)</SPAN></P> <P>&nbsp;</P> <P><SPAN>Please note the databricks MLflow connection is working fine from data load editor. the above expression is not working.</SPAN></P> <P><SPAN>Kindly help.</SPAN></P> <P>&nbsp;</P> <P><SPAN>thank you.<BR />Sandeep</SPAN></P> <P><BR /><BR /><SPAN>requesting your guidance to achieve this as I am not getting correct values in EXPRESSION editor</SPAN></P> Wed, 08 Mar 2023 11:03:28 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Databricks-MLFlow/m-p/2046708#M12127 sandeepk218 2023-03-08T11:03:28Z