Qlik AutoML: How to join predicted output to original trained dataset

[KellyHobson]

After generating model predictions in Qlik AutoML on Qlik Cloud, you can view the data in a Qlik Sense App. This way the data is hosted in the Cloud and you can view your output with Qlik Sense while it remains staged in the Catalog.

Viewing predictions helps to understand the model output and is also useful in generating visualizations.

For this example, we pick up from the previous article (Qlik AutoML: How to upload, model, deploy, and predict on the Qlik Cloud platform) after we have generated the predictions.

Note: in this example, there is an 'ID' column linking all tables together in a 1-to-1 relationship.

1. Navigate to Qlik Cloud Console and Catalog. In this example, I've generated predictions for a Gradient Boost model (_XGBR)
   
   
   
   
2. Go to Add new -> "New Analytics App"
   
   
   
   
3. Give it a meaningful name and click "Create"
   
   
   
   
4. In this example, we will generate from files in Data Catalog
   
   
   
   
5. Select ….Prediction_XGBR_SHAP, …Prediction_XGBR and the original dataset insurancev2.csv then click 'Next' on bottom right, the 'Load into App'
   
   
   
   
6. This will display the 'Data Manager' page. Click 'Apply' on the recommended associations on the right hand side of the page
   
   
   
   
7. Now the tables will be linked by the common 'ID' value between all tables
   
   
   
   
8. In order to combine the datasets into 1 table for additional analysis, we will do simple Left join on ID. Select 1 of the tables and then click 'Concatenate or Join'
   
   
   
   Will produce:
   
   
   
   Select Left Join then Apply
   
   
   
   Produces a combined table:
   
   
   
   
9. Now follow the same steps to combing insurancev2_Prediction_XGBR with insurancev2. Select insurancev2_Prediction_XGBR and click 'Concatenate or join'. Select left join and apply.
   
   
   
   
10. Now, we have 1 table with columns from all three tables which were joined by 'ID'. Click on 'Load Data' in top right corner to load the data into the app and begin making visualizations or exploring SHAP values.
    
    
    
    After clicking 'Load Data':
    
    

More info to come about Visualizations you can create in Qlik Sense!

Environment

• Qlik AutoML 

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.