topic Re: Apply multiple selection to the report in Qlik Automate

Apply multiple selection to the report

OlivierS — Mon, 03 Apr 2023 16:12:06 GMT

Hello,

I succeeded applying a selection on the report send through a mail in a pdf format but so far these selection must be unique field value.

I use a button with a automation Http request formated in that way:

'https://COMPANY.eu.qlikcloud.com/api/v1/automations/AUTOID/actions/execute?X-Execution-Token=TOKEN&user=$(UserInfo)&domain=$(=concat(Distinct Domain,'-'))&skill=$(=concat(Distinct Skill,'-'))'

I have set a delimiter configuration into my select field value block, just entered - into the box and tried '-' as well....

Into the report block chain, i applied the add selection with a input> FieldName.

Works perfectly if i have a single selection, but won't take any selection if multiple values are selected.

What have i missed

Re: Apply multiple selection to the report

Madhushree_BP — Tue, 04 Apr 2023 08:11:06 GMT

Hi @OlivierS ,

Using - in the input, Field Value Delimiter of the select field value block should work to select multiple field values.

Can you please share the automation JSON file, I will have a look into it to check if anything is missing.

To download the automation JSON file, Right Click on the editor -> Download Workspcae.

Thanks,

Madhushree

Re: Apply multiple selection to the report

OlivierS — Tue, 04 Apr 2023 08:20:12 GMT

Hey Madhushree_BP,

Here is the json code, couldn't attach it to this message due to a "Not Matcht Content/File Ext".

There might be a couple of disable block set asside, i'm currently working on the automation 🙂 The chain described above is set on active

{"blocks":[{"id":"58076C8B-86EA-4FE5-B7C4-978782FCED27","type":"StartBlock","disabled":false,"name":"Start","displayName":"Start","comment":"This template will generate a report of an app and send it in an email as a PDF file attachment. Set the Run mode to Scheduled and define your recipients in the recipients Variable block.","childId":"256C65DC-B809-4314-AC31-03D7BEE12760","inputs":[{"id":"run_mode","value":"triggered","type":"select","structure":{}},{"id":"async","value":"no","type":"select","structure":{}},{"id":"","value":null,"type":"custom","structure":{}}],"settings":[],"collapsed":[{"name":"loop","isCollapsed":false}],"x":266,"y":64,"logo":null},{"id":"62669A0D-175C-4269-B63F-9B25F74B36E9","type":"QlikReportingCreateReportBlock","disabled":false,"name":"createReport","displayName":"Evaluation Report - Create Report","comment":"Specify the app ID and report name. Set the sheets mode to All to include all public sheets in the report.","childId":"DA9A551D-7BFF-4913-AE37-C012F0ADD4A9","inputs":[{"id":"app_id","value":"c3b3d1d3-25f4-4e29-a5cd-f64b4f7cb2dd","type":"string","displayValue":"Training Reporting (c3b3d1d3-25f4-4e29-a5cd-f64b4f7cb2dd)","structure":[]},{"id":"name","value":"Evaluation Report","type":"string","structure":[]},{"id":"sheets_mode","value":"custom","type":"select","displayValue":"Custom","structure":[]}],"settings":[],"collapsed":[{"name":"loop","isCollapsed":false}],"x":675,"y":974.0003291819828},{"id":"638646B2-CA84-4E52-B1EF-3517A419325D","type":"QlikReportingGenerateReportBlock","disabled":false,"name":"generateReport","displayName":"Evaluation Report - Generate Report","comment":"This block will generate the report. The output of this block can be used in the Cloud storage and Mail connectors.","childId":"800224B2-8DCF-4FD3-8BB8-EFB9C22EDBA9","inputs":[{"id":"report","value":"62669A0D-175C-4269-B63F-9B25F74B36E9","type":"select","displayValue":"Create Report","structure":[]},{"id":"format","value":"pdf","type":"select","structure":[]}],"settings":[{"id":"blendr_on_error","value":"stop","type":"select","structure":[]}],"collapsed":[{"name":"loop","isCollapsed":false}],"x":100,"y":460},{"id":"800224B2-8DCF-4FD3-8BB8-EFB9C22EDBA9","type":"EndpointBlock","disabled":false,"name":"SendMail","displayName":"Mail - Send Mail","comment":"Send an email to all recipients. Feel free to replace this block with the Copy File block from the Cloud storage connector to save the generated PDF file on a cloud storage tool.","childId":null,"inputs":[{"id":"442845a0-cd00-11eb-9aa5-b966a68573b7","value":"{$.GetStraightTableData[0].Email}","type":"string","structure":[]},{"id":"543f08c0-cd00-11eb-b9c6-af8e23cc2439","value":null,"type":"string","structure":[]},{"id":"5cbdb1d0-cd00-11eb-8afd-ddd4ecc002ac","value":null,"type":"string","structure":[]},{"id":"72cad1e0-cd00-11eb-aa1b-3f42c1d22e38","value":"Rapport d'autoévaluation du : {date: 'now', 'd-m-y'}","type":"string","structure":[]},{"id":"79af8c50-cd24-11eb-a019-dfdc9a7f7317","value":"90ff46f0-cd24-11eb-bda1-0f1c7c213bfb","type":"select","displayValue":"html","structure":[]},{"id":"7d225d00-cd00-11eb-8493-055760e8b45a","value":"<!DOCTYPE html>\r\n<html>\r\n<head>\r\n <title>Page Title</title>\r\n</head>\r\n<body>\r\n <div style=\"text-align:center;\">\r\n <img src=\"https://COMPANY.be/wp-content/uploads/2019/08/COMPANY_color_bgtransparent.png\" alt=\"Weqan\" width=50% heigh=50%;\">\r\n </div>\r\n <p style=\"text-align:left;\">Bonjour {$.GetStraightTableData[0].FirstName} <p style=\"text-align:left;\">Voici le résumé de ton autoévaluation et des données préalablement encodées dans l'application.</p>\r\n <p style=\"text-align:left;\">Tu peux à tout moment effectuer une nouvelle évaluation en te rendant à nouveau dans <a href=\"https://reporting-COMPANY .eu.qlikcloud.com/sense/app/APPID/sheet/3b587988-89e4-4829-add1-68502b1c4052/state/analysis\">l'application d'autoévaluation</a>.</p>\r\n <p style=\"text-align:left;\">N'oublie pas, seuls les derniers résultats d'évaluation comptent dans le résultat final. Si tu estimes avoir fait une erreur, tu peux à tout moment la corriger en remplissant à nouveau une évaluation ;).</p>\r\n\n</body>\r\n</html>","type":"longtext","structure":[]},{"id":"bb841f10-3341-11ec-b9a3-9d6de0bb7866","value":[{"value":"638646B2-CA84-4E52-B1EF-3517A419325D"}],"type":"custom","structure":[]}],"settings":[{"id":"datasource","value":null,"type":"select","structure":[]},{"id":"blendr_on_error","value":"stop","type":"select","structure":[]}],"collapsed":[{"name":"loop","isCollapsed":false}],"x":266,"y":904,"datasourcetype_guid":"05407a80-ccfd-11eb-b098-7140f6ac27f4","endpoint_guid":"84a79bf0-ccff-11eb-a508-7d415a725ea7","endpoint_role":"create"},{"id":"84B92D00-1B98-4715-8F2A-06782722A7CC","type":"QlikReportingAddSheetToReportBlock","disabled":false,"name":"addSheetToReport","displayName":"Reporting - Add Sheet To Report","comment":"","childId":"638646B2-CA84-4E52-B1EF-3517A419325D","inputs":[{"id":"report","value":"62669A0D-175C-4269-B63F-9B25F74B36E9","type":"select","displayValue":"Create Report (Evaluation Report)","structure":[]},{"id":"sheet","value":"ed04f647-8d0a-423c-8f86-66c6b4f27a77","type":"string","displayValue":"Reporting","structure":[]}],"settings":[],"collapsed":[{"name":"loop","isCollapsed":false}],"x":266,"y":1064},{"id":"DA9A551D-7BFF-4913-AE37-C012F0ADD4A9","type":"QlikReportingAddSelectionToReportBlock","disabled":false,"name":"addSelectionToReport","displayName":"Evaluation Report - Add Selection To Report","comment":"User Select\n","childId":"B681BED7-51D5-4F0D-95A0-FE429C4E2AF8","inputs":[{"id":"report","value":"62669A0D-175C-4269-B63F-9B25F74B36E9","type":"select","displayValue":"Create Report (Evaluation Report)","structure":[]},{"id":"field","value":"%user","type":"string","displayValue":"%user","structure":[]},{"id":"values","value":["{$.inputs.user}"],"type":"list","mode":"keyValue","structure":[]},{"id":"state","value":"$","type":"string","structure":[]}],"settings":[],"collapsed":[{"name":"loop","isCollapsed":false}],"x":1022,"y":788.9982992264222},{"id":"256C65DC-B809-4314-AC31-03D7BEE12760","type":"FormBlock","disabled":false,"name":"inputs","displayName":"Inputs","comment":"","childId":"2B192C17-644C-43C5-BCCA-21986C40BEEB","inputs":[],"settings":[{"id":"persist_data","value":"no","type":"select","structure":{}}],"collapsed":[{"name":"loop","isCollapsed":false}],"x":266,"y":304,"form":[{"id":"inputs-input-0","label":"user","helpText":null,"type":"input","values":null,"isRequired":true,"options":{},"order":0},{"id":"inputs-input-1","label":"domain","helpText":null,"type":"input","values":null,"isRequired":true,"options":{},"order":1},{"id":"inputs-input-2","label":"skill","helpText":null,"type":"input","values":null,"isRequired":true,"options":{},"order":2}],"persistData":"no"},{"id":"2B192C17-644C-43C5-BCCA-21986C40BEEB","type":"SnippetBlock","disabled":false,"name":"SelectFieldValue","displayName":"Qlik Cloud Services - Select Field Value","comment":"user","childId":"D3A4C877-FFEC-45BD-9DCF-335A8858FE5B","inputs":[{"id":"5c519bb0-2746-11eb-90b8-bd6cdd038eea","value":"c3b3d1d3-25f4-4e29-a5cd-f64b4f7cb2dd","type":"string","displayValue":"Training Reporting (c3b3d1d3-25f4-4e29-a5cd-f64b4f7cb2dd)","structure":{}},{"id":"5c51e4d0-2746-11eb-a6e9-cb3780a2408a","value":"%user","type":"string","displayValue":"%user","structure":{}},{"id":"5c521a90-2746-11eb-b6b5-2bcd8bdab044","value":"{$.inputs.user}","type":"string","structure":{}},{"id":"86ec2b50-a8fa-11ec-a6df-71744fe2f6b6","value":",","type":"string","structure":{}},{"id":"86ed23b0-a8fa-11ec-b952-d951089a6651","value":null,"type":"string","structure":{}},{"id":"86c71730-1554-11ec-b612-cfd450c2f483","value":null,"type":"select","structure":{}}],"settings":[{"id":"blendr_on_error","value":"stop","type":"select","structure":{}}],"collapsed":[{"name":"loop","isCollapsed":false}],"x":266,"y":424,"datasourcetype_guid":"61a87510-c7a3-11ea-95da-0fb0c241e75c","snippet_guid":"00a75720-2746-11eb-8e2b-3922badcee03"},{"id":"10AD8381-02D4-4CE4-924E-F512C4E2070D","type":"SnippetBlock","disabled":false,"name":"GetStraightTableData","displayName":"Qlik Cloud Services - Get Straight Table Data","comment":"","childId":"62669A0D-175C-4269-B63F-9B25F74B36E9","inputs":[{"id":"702aa990-e7d6-11ea-9155-5563fc8a0200","value":"c3b3d1d3-25f4-4e29-a5cd-f64b4f7cb2dd","type":"string","displayValue":"Training Reporting (c3b3d1d3-25f4-4e29-a5cd-f64b4f7cb2dd)","structure":{}},{"id":"5295ea90-1fa5-11eb-8b61-a1195c91b158","value":"d6f9c7e3-5b8e-4d5d-924f-b952d18b1862","type":"string","displayValue":"6 - Reporting Data","structure":{}},{"id":"702b4760-e7d6-11ea-bd24-c3ad734592ce","value":"JZmDmpf","type":"string","displayValue":"SELECTION TABLE - JZmDmpf - table - row 0 col 0","structure":{}}],"settings":[{"id":"blendr_on_error","value":"stop","type":"select","structure":{}}],"collapsed":[{"name":"loop","isCollapsed":false}],"x":266,"y":664,"datasourcetype_guid":"61a87510-c7a3-11ea-95da-0fb0c241e75c","snippet_guid":"70247640-e7d6-11ea-b140-a1d938943465"},{"id":"B681BED7-51D5-4F0D-95A0-FE429C4E2AF8","type":"QlikReportingAddSelectionToReportBlock","disabled":false,"name":"addSelectionToReport2","displayName":"Evaluation Report - Add Selection To Report 2","comment":"Domain Select\n","childId":"4BC6E69F-07D9-47C7-94AA-ADC72A656FDB","inputs":[{"id":"report","value":"62669A0D-175C-4269-B63F-9B25F74B36E9","type":"select","displayValue":"Create Report (Evaluation Report)","structure":[]},{"id":"field","value":"Domain","type":"string","displayValue":"Domain","structure":[]},{"id":"values","value":["{$.inputs.domain}"],"type":"list","mode":"keyValue","structure":[]},{"id":"state","value":"$","type":"string","structure":[]}],"settings":[],"collapsed":[{"name":"loop","isCollapsed":false}],"x":266,"y":1184},{"id":"D3A4C877-FFEC-45BD-9DCF-335A8858FE5B","type":"SnippetBlock","disabled":false,"name":"SelectFieldValue2","displayName":"Qlik Cloud Services - Select Field Value 2","comment":"domain","childId":"4A9ED57F-7288-4DC9-9EAA-CF8274172CAB","inputs":[{"id":"5c519bb0-2746-11eb-90b8-bd6cdd038eea","value":"c3b3d1d3-25f4-4e29-a5cd-f64b4f7cb2dd","type":"string","displayValue":"Training Reporting (c3b3d1d3-25f4-4e29-a5cd-f64b4f7cb2dd)","structure":{}},{"id":"5c51e4d0-2746-11eb-a6e9-cb3780a2408a","value":"Domain","type":"string","displayValue":"Domain","structure":{}},{"id":"5c521a90-2746-11eb-b6b5-2bcd8bdab044","value":"{$.inputs.domain}","type":"string","structure":{}},{"id":"86ec2b50-a8fa-11ec-a6df-71744fe2f6b6","value":"-","type":"string","structure":{}},{"id":"86ed23b0-a8fa-11ec-b952-d951089a6651","value":null,"type":"string","structure":{}},{"id":"86c71730-1554-11ec-b612-cfd450c2f483","value":null,"type":"select","structure":{}}],"settings":[{"id":"blendr_on_error","value":"stop","type":"select","structure":{}}],"collapsed":[{"name":"loop","isCollapsed":false}],"x":266,"y":544,"datasourcetype_guid":"61a87510-c7a3-11ea-95da-0fb0c241e75c","snippet_guid":"00a75720-2746-11eb-8e2b-3922badcee03"},{"id":"4A9ED57F-7288-4DC9-9EAA-CF8274172CAB","type":"SnippetBlock","disabled":false,"name":"SelectFieldValue3","displayName":"Qlik Cloud Services - Select Field Value 3","comment":"skill","childId":"10AD8381-02D4-4CE4-924E-F512C4E2070D","inputs":[{"id":"5c519bb0-2746-11eb-90b8-bd6cdd038eea","value":"c3b3d1d3-25f4-4e29-a5cd-f64b4f7cb2dd","type":"string","displayValue":"Training Reporting (c3b3d1d3-25f4-4e29-a5cd-f64b4f7cb2dd)","structure":{}},{"id":"5c51e4d0-2746-11eb-a6e9-cb3780a2408a","value":"Skill","type":"string","displayValue":"Skill","structure":{}},{"id":"5c521a90-2746-11eb-b6b5-2bcd8bdab044","value":"{$.inputs.skill}","type":"string","structure":{}},{"id":"86ec2b50-a8fa-11ec-a6df-71744fe2f6b6","value":"-","type":"string","structure":{}},{"id":"86ed23b0-a8fa-11ec-b952-d951089a6651","value":null,"type":"string","structure":{}},{"id":"86c71730-1554-11ec-b612-cfd450c2f483","value":null,"type":"select","structure":{}}],"settings":[{"id":"blendr_on_error","value":"stop","type":"select","structure":{}}],"collapsed":[{"name":"loop","isCollapsed":false}],"x":516,"y":544,"datasourcetype_guid":"61a87510-c7a3-11ea-95da-0fb0c241e75c","snippet_guid":"00a75720-2746-11eb-8e2b-3922badcee03"},{"id":"4BC6E69F-07D9-47C7-94AA-ADC72A656FDB","type":"QlikReportingAddSelectionToReportBlock","disabled":false,"name":"addSelectionToReport3","displayName":"Evaluation Report - Add Selection To Report 3","comment":"Skill Select\n","childId":"84B92D00-1B98-4715-8F2A-06782722A7CC","inputs":[{"id":"report","value":"62669A0D-175C-4269-B63F-9B25F74B36E9","type":"select","displayValue":"Create Report (Evaluation Report)","structure":[]},{"id":"field","value":"Skill","type":"string","displayValue":"Skill","structure":[]},{"id":"values","value":["{$.inputs.skill}"],"type":"list","mode":"keyValue","structure":[]},{"id":"state","value":"$","type":"string","structure":[]}],"settings":[],"collapsed":[{"name":"loop","isCollapsed":false}],"x":516,"y":1184},{"id":"141C7266-0BE9-4518-8512-7AE1FCB7AB50","type":"SnippetBlock","disabled":true,"name":"listCurrentSelections","displayName":"Qlik Cloud Services - List Current Selections","comment":"","childId":null,"inputs":[{"id":"99bc8380-2067-11ec-a0ee-c55177fde1d2","value":"c3b3d1d3-25f4-4e29-a5cd-f64b4f7cb2dd","type":"string","displayValue":"Training Reporting (c3b3d1d3-25f4-4e29-a5cd-f64b4f7cb2dd)","structure":{}}],"settings":[{"id":"blendr_on_error","value":"stop","type":"select","structure":{}}],"collapsed":[{"name":"loop","isCollapsed":false}],"x":1641,"y":747.9978493443791,"loopBlockId":"0BD3E2B6-E14E-4450-B8AB-1D1F7B415820","datasourcetype_guid":"61a87510-c7a3-11ea-95da-0fb0c241e75c","snippet_guid":"99b9b8f0-2067-11ec-baaf-9db1f5f660b2"},{"id":"2343A10C-D45A-4002-8D0F-317B29449903","type":"ShowBlock","disabled":true,"name":"output","displayName":"Output","comment":"","childId":null,"inputs":[{"id":"input","value":"{ $.listCurrentSelections.item }","type":"string","structure":{}}],"settings":[{"id":"display_mode","value":"add","type":"select","structure":{}}],"collapsed":[{"name":"loop","isCollapsed":false}],"x":-89,"y":689},{"id":"ACEB3418-0EE0-4D4A-9885-8A03708E2D7B","type":"QlikReportingCreateReportBlock","disabled":true,"name":"createReport2","displayName":"Evaluation Report - Create Report 2","comment":"Specify the app ID and report name. Set the sheets mode to All to include all public sheets in the report.","childId":null,"inputs":[{"id":"app_id","value":"c3b3d1d3-25f4-4e29-a5cd-f64b4f7cb2dd","type":"string","displayValue":"Training Reporting (c3b3d1d3-25f4-4e29-a5cd-f64b4f7cb2dd)","structure":[]},{"id":"name","value":"Evaluation Report","type":"string","structure":[]},{"id":"sheets_mode","value":"custom","type":"select","displayValue":"Custom","structure":[]}],"settings":[],"collapsed":[{"name":"loop","isCollapsed":false}],"x":1454,"y":701.9986613266035},{"id":"0BD3E2B6-E14E-4450-B8AB-1D1F7B415820","type":"QlikReportingAddSelectionToReportBlock","disabled":true,"name":"addSelectionToReport4","displayName":"Evaluation Report - Add Selection To Report 4","comment":"User Select\n","childId":"2343A10C-D45A-4002-8D0F-317B29449903","inputs":[{"id":"report","value":"62669A0D-175C-4269-B63F-9B25F74B36E9","type":"select","displayValue":"Create Report (Evaluation Report)","structure":[]},{"id":"field","value":"%user","type":"string","displayValue":"%user","structure":[]},{"id":"values","value":["{$.inputs.user}"],"type":"list","mode":"keyValue","structure":[]},{"id":"state","value":"$","type":"string","structure":[]}],"settings":[],"collapsed":[{"name":"loop","isCollapsed":false}],"x":1272,"y":788.9982992264222}],"variables":[{"guid":"8F720502-FDF3-4B08-8F2A-D455689D406C","name":"recipients","type":"list"},{"guid":"38591B0D-F820-4985-8816-57C29530E5E4","name":"template64","type":"string"}]}

Re: Apply multiple selection to the report

OlivierS — Tue, 04 Apr 2023 09:15:43 GMT

I download the file but the drag and drop system keeps kicking it from the message.

Here is the content

{"blocks":[{"id":"58076C8B-86EA-4FE5-B7C4-978782FCED27","type":"StartBlock","disabled":false,"name":"Start","displayName":"Start","comment":"This template will generate a report of an app and send it in an email as a PDF file attachment. Set the Run mode to Scheduled and define your recipients in the recipients Variable block.","childId":"256C65DC-B809-4314-AC31-03D7BEE12760","inputs":[{"id":"run_mode","value":"triggered","type":"select","structure":{}},{"id":"async","value":"no","type":"select","structure":{}},{"id":"","value":null,"type":"custom","structure":{}}],"settings":[],"collapsed":[{"name":"loop","isCollapsed":false}],"x":266,"y":64,"logo":null},{"id":"62669A0D-175C-4269-B63F-9B25F74B36E9","type":"QlikReportingCreateReportBlock","disabled":false,"name":"createReport","displayName":"Evaluation Report - Create Report","comment":"Specify the app ID and report name. Set the sheets mode to All to include all public sheets in the report.","childId":"DA9A551D-7BFF-4913-AE37-C012F0ADD4A9","inputs":[{"id":"app_id","value":"c3b3d1d3-25f4-4e29-a5cd-f64b4f7cb2dd","type":"string","displayValue":"Training Reporting (c3b3d1d3-25f4-4e29-a5cd-f64b4f7cb2dd)","structure":[]},{"id":"name","value":"Evaluation Report","type":"string","structure":[]},{"id":"sheets_mode","value":"custom","type":"select","displayValue":"Custom","structure":[]}],"settings":[],"collapsed":[{"name":"loop","isCollapsed":false}],"x":675,"y":974.0003291819828},{"id":"638646B2-CA84-4E52-B1EF-3517A419325D","type":"QlikReportingGenerateReportBlock","disabled":false,"name":"generateReport","displayName":"Evaluation Report - Generate Report","comment":"This block will generate the report. The output of this block can be used in the Cloud storage and Mail connectors.","childId":"800224B2-8DCF-4FD3-8BB8-EFB9C22EDBA9","inputs":[{"id":"report","value":"62669A0D-175C-4269-B63F-9B25F74B36E9","type":"select","displayValue":"Create Report","structure":[]},{"id":"format","value":"pdf","type":"select","structure":[]}],"settings":[{"id":"blendr_on_error","value":"stop","type":"select","structure":[]}],"collapsed":[{"name":"loop","isCollapsed":false}],"x":100,"y":460},{"id":"800224B2-8DCF-4FD3-8BB8-EFB9C22EDBA9","type":"EndpointBlock","disabled":false,"name":"SendMail","displayName":"Mail - Send Mail","comment":"Send an email to all recipients. Feel free to replace this block with the Copy File block from the Cloud storage connector to save the generated PDF file on a cloud storage tool.","childId":null,"inputs":[{"id":"442845a0-cd00-11eb-9aa5-b966a68573b7","value":"{$.GetStraightTableData[0].Email}","type":"string","structure":[]},{"id":"543f08c0-cd00-11eb-b9c6-af8e23cc2439","value":null,"type":"string","structure":[]},{"id":"5cbdb1d0-cd00-11eb-8afd-ddd4ecc002ac","value":null,"type":"string","structure":[]},{"id":"72cad1e0-cd00-11eb-aa1b-3f42c1d22e38","value":"Rapport d'autoévaluation du : {date: 'now', 'd-m-y'}","type":"string","structure":[]},{"id":"79af8c50-cd24-11eb-a019-dfdc9a7f7317","value":"90ff46f0-cd24-11eb-bda1-0f1c7c213bfb","type":"select","displayValue":"html","structure":[]},{"id":"7d225d00-cd00-11eb-8493-055760e8b45a","value":"<!DOCTYPE html>\r\n<html>\r\n<head>\r\n <title>Page Title</title>\r\n</head>\r\n<body>\r\n <div style=\"text-align:center;\">\r\n <img src=\"https://weqan.be/wp-content/uploads/2019/08/weqan_color_bgtransparent.png\" alt=\"Weqan\" width=50% heigh=50%;\">\r\n </div>\r\n <p style=\"text-align:left;\">Bonjour {$.GetStraightTableData[0].FirstName} <p style=\"text-align:left;\">Voici le résumé de ton autoévaluation et des données préalablement encodées dans l'application.</p>\r\n <p style=\"text-align:left;\">Tu peux à tout moment effectuer une nouvelle évaluation en te rendant à nouveau dans <a href=\"https://reporting-weqan.eu.qlikcloud.com/sense/app/741143bf-d1f7-4b83-8dbe-0725761d205f/sheet/3b587988-89e4-4829-add1-68502b1c4052/state/analysis\">l'application d'autoévaluation</a>.</p>\r\n <p style=\"text-align:left;\">N'oublie pas, seuls les derniers résultats d'évaluation comptent dans le résultat final. Si tu estimes avoir fait une erreur, tu peux à tout moment la corriger en remplissant à nouveau une évaluation ;).</p>\r\n\n</body>\r\n</html>","type":"longtext","structure":[]},{"id":"bb841f10-3341-11ec-b9a3-9d6de0bb7866","value":[{"value":"638646B2-CA84-4E52-B1EF-3517A419325D"}],"type":"custom","structure":[]}],"settings":[{"id":"datasource","value":null,"type":"select","structure":[]},{"id":"blendr_on_error","value":"stop","type":"select","structure":[]}],"collapsed":[{"name":"loop","isCollapsed":false}],"x":266,"y":904,"datasourcetype_guid":"05407a80-ccfd-11eb-b098-7140f6ac27f4","endpoint_guid":"84a79bf0-ccff-11eb-a508-7d415a725ea7","endpoint_role":"create"},{"id":"84B92D00-1B98-4715-8F2A-06782722A7CC","type":"QlikReportingAddSheetToReportBlock","disabled":false,"name":"addSheetToReport","displayName":"Reporting - Add Sheet To Report","comment":"","childId":"638646B2-CA84-4E52-B1EF-3517A419325D","inputs":[{"id":"report","value":"62669A0D-175C-4269-B63F-9B25F74B36E9","type":"select","displayValue":"Create Report (Evaluation Report)","structure":[]},{"id":"sheet","value":"ed04f647-8d0a-423c-8f86-66c6b4f27a77","type":"string","displayValue":"Reporting","structure":[]}],"settings":[],"collapsed":[{"name":"loop","isCollapsed":false}],"x":266,"y":1064},{"id":"DA9A551D-7BFF-4913-AE37-C012F0ADD4A9","type":"QlikReportingAddSelectionToReportBlock","disabled":false,"name":"addSelectionToReport","displayName":"Evaluation Report - Add Selection To Report","comment":"User Select\n","childId":"B681BED7-51D5-4F0D-95A0-FE429C4E2AF8","inputs":[{"id":"report","value":"62669A0D-175C-4269-B63F-9B25F74B36E9","type":"select","displayValue":"Create Report (Evaluation Report)","structure":[]},{"id":"field","value":"%user","type":"string","displayValue":"%user","structure":[]},{"id":"values","value":["{$.inputs.user}"],"type":"list","mode":"keyValue","structure":[]},{"id":"state","value":"$","type":"string","structure":[]}],"settings":[],"collapsed":[{"name":"loop","isCollapsed":false}],"x":1022,"y":788.9982992264222},{"id":"256C65DC-B809-4314-AC31-03D7BEE12760","type":"FormBlock","disabled":false,"name":"inputs","displayName":"Inputs","comment":"","childId":"2B192C17-644C-43C5-BCCA-21986C40BEEB","inputs":[],"settings":[{"id":"persist_data","value":"no","type":"select","structure":{}}],"collapsed":[{"name":"loop","isCollapsed":false}],"x":266,"y":304,"form":[{"id":"inputs-input-0","label":"user","helpText":null,"type":"input","values":null,"isRequired":true,"options":{},"order":0},{"id":"inputs-input-1","label":"domain","helpText":null,"type":"input","values":null,"isRequired":true,"options":{},"order":1},{"id":"inputs-input-2","label":"skill","helpText":null,"type":"input","values":null,"isRequired":true,"options":{},"order":2}],"persistData":"no"},{"id":"2B192C17-644C-43C5-BCCA-21986C40BEEB","type":"SnippetBlock","disabled":false,"name":"SelectFieldValue","displayName":"Qlik Cloud Services - Select Field Value","comment":"user","childId":"D3A4C877-FFEC-45BD-9DCF-335A8858FE5B","inputs":[{"id":"5c519bb0-2746-11eb-90b8-bd6cdd038eea","value":"c3b3d1d3-25f4-4e29-a5cd-f64b4f7cb2dd","type":"string","displayValue":"Training Reporting (c3b3d1d3-25f4-4e29-a5cd-f64b4f7cb2dd)","structure":{}},{"id":"5c51e4d0-2746-11eb-a6e9-cb3780a2408a","value":"%user","type":"string","displayValue":"%user","structure":{}},{"id":"5c521a90-2746-11eb-b6b5-2bcd8bdab044","value":"{$.inputs.user}","type":"string","structure":{}},{"id":"86ec2b50-a8fa-11ec-a6df-71744fe2f6b6","value":",","type":"string","structure":{}},{"id":"86ed23b0-a8fa-11ec-b952-d951089a6651","value":null,"type":"string","structure":{}},{"id":"86c71730-1554-11ec-b612-cfd450c2f483","value":null,"type":"select","structure":{}}],"settings":[{"id":"blendr_on_error","value":"stop","type":"select","structure":{}}],"collapsed":[{"name":"loop","isCollapsed":false}],"x":266,"y":424,"datasourcetype_guid":"61a87510-c7a3-11ea-95da-0fb0c241e75c","snippet_guid":"00a75720-2746-11eb-8e2b-3922badcee03"},{"id":"10AD8381-02D4-4CE4-924E-F512C4E2070D","type":"SnippetBlock","disabled":false,"name":"GetStraightTableData","displayName":"Qlik Cloud Services - Get Straight Table Data","comment":"","childId":"62669A0D-175C-4269-B63F-9B25F74B36E9","inputs":[{"id":"702aa990-e7d6-11ea-9155-5563fc8a0200","value":"c3b3d1d3-25f4-4e29-a5cd-f64b4f7cb2dd","type":"string","displayValue":"Training Reporting (c3b3d1d3-25f4-4e29-a5cd-f64b4f7cb2dd)","structure":{}},{"id":"5295ea90-1fa5-11eb-8b61-a1195c91b158","value":"d6f9c7e3-5b8e-4d5d-924f-b952d18b1862","type":"string","displayValue":"6 - Reporting Data","structure":{}},{"id":"702b4760-e7d6-11ea-bd24-c3ad734592ce","value":"JZmDmpf","type":"string","displayValue":"SELECTION TABLE - JZmDmpf - table - row 0 col 0","structure":{}}],"settings":[{"id":"blendr_on_error","value":"stop","type":"select","structure":{}}],"collapsed":[{"name":"loop","isCollapsed":false}],"x":266,"y":664,"datasourcetype_guid":"61a87510-c7a3-11ea-95da-0fb0c241e75c","snippet_guid":"70247640-e7d6-11ea-b140-a1d938943465"},{"id":"B681BED7-51D5-4F0D-95A0-FE429C4E2AF8","type":"QlikReportingAddSelectionToReportBlock","disabled":false,"name":"addSelectionToReport2","displayName":"Evaluation Report - Add Selection To Report 2","comment":"Domain Select\n","childId":"4BC6E69F-07D9-47C7-94AA-ADC72A656FDB","inputs":[{"id":"report","value":"62669A0D-175C-4269-B63F-9B25F74B36E9","type":"select","displayValue":"Create Report (Evaluation Report)","structure":[]},{"id":"field","value":"Domain","type":"string","displayValue":"Domain","structure":[]},{"id":"values","value":["{$.inputs.domain}"],"type":"list","mode":"keyValue","structure":[]},{"id":"state","value":"$","type":"string","structure":[]}],"settings":[],"collapsed":[{"name":"loop","isCollapsed":false}],"x":266,"y":1184},{"id":"D3A4C877-FFEC-45BD-9DCF-335A8858FE5B","type":"SnippetBlock","disabled":false,"name":"SelectFieldValue2","displayName":"Qlik Cloud Services - Select Field Value 2","comment":"domain","childId":"4A9ED57F-7288-4DC9-9EAA-CF8274172CAB","inputs":[{"id":"5c519bb0-2746-11eb-90b8-bd6cdd038eea","value":"c3b3d1d3-25f4-4e29-a5cd-f64b4f7cb2dd","type":"string","displayValue":"Training Reporting (c3b3d1d3-25f4-4e29-a5cd-f64b4f7cb2dd)","structure":{}},{"id":"5c51e4d0-2746-11eb-a6e9-cb3780a2408a","value":"Domain","type":"string","displayValue":"Domain","structure":{}},{"id":"5c521a90-2746-11eb-b6b5-2bcd8bdab044","value":"{$.inputs.domain}","type":"string","structure":{}},{"id":"86ec2b50-a8fa-11ec-a6df-71744fe2f6b6","value":"-","type":"string","structure":{}},{"id":"86ed23b0-a8fa-11ec-b952-d951089a6651","value":null,"type":"string","structure":{}},{"id":"86c71730-1554-11ec-b612-cfd450c2f483","value":null,"type":"select","structure":{}}],"settings":[{"id":"blendr_on_error","value":"stop","type":"select","structure":{}}],"collapsed":[{"name":"loop","isCollapsed":false}],"x":266,"y":544,"datasourcetype_guid":"61a87510-c7a3-11ea-95da-0fb0c241e75c","snippet_guid":"00a75720-2746-11eb-8e2b-3922badcee03"},{"id":"4A9ED57F-7288-4DC9-9EAA-CF8274172CAB","type":"SnippetBlock","disabled":false,"name":"SelectFieldValue3","displayName":"Qlik Cloud Services - Select Field Value 3","comment":"skill","childId":"10AD8381-02D4-4CE4-924E-F512C4E2070D","inputs":[{"id":"5c519bb0-2746-11eb-90b8-bd6cdd038eea","value":"c3b3d1d3-25f4-4e29-a5cd-f64b4f7cb2dd","type":"string","displayValue":"Training Reporting (c3b3d1d3-25f4-4e29-a5cd-f64b4f7cb2dd)","structure":{}},{"id":"5c51e4d0-2746-11eb-a6e9-cb3780a2408a","value":"Skill","type":"string","displayValue":"Skill","structure":{}},{"id":"5c521a90-2746-11eb-b6b5-2bcd8bdab044","value":"{$.inputs.skill}","type":"string","structure":{}},{"id":"86ec2b50-a8fa-11ec-a6df-71744fe2f6b6","value":"-","type":"string","structure":{}},{"id":"86ed23b0-a8fa-11ec-b952-d951089a6651","value":null,"type":"string","structure":{}},{"id":"86c71730-1554-11ec-b612-cfd450c2f483","value":null,"type":"select","structure":{}}],"settings":[{"id":"blendr_on_error","value":"stop","type":"select","structure":{}}],"collapsed":[{"name":"loop","isCollapsed":false}],"x":516,"y":544,"datasourcetype_guid":"61a87510-c7a3-11ea-95da-0fb0c241e75c","snippet_guid":"00a75720-2746-11eb-8e2b-3922badcee03"},{"id":"4BC6E69F-07D9-47C7-94AA-ADC72A656FDB","type":"QlikReportingAddSelectionToReportBlock","disabled":false,"name":"addSelectionToReport3","displayName":"Evaluation Report - Add Selection To Report 3","comment":"Skill Select\n","childId":"84B92D00-1B98-4715-8F2A-06782722A7CC","inputs":[{"id":"report","value":"62669A0D-175C-4269-B63F-9B25F74B36E9","type":"select","displayValue":"Create Report (Evaluation Report)","structure":[]},{"id":"field","value":"Skill","type":"string","displayValue":"Skill","structure":[]},{"id":"values","value":["{$.inputs.skill}"],"type":"list","mode":"keyValue","structure":[]},{"id":"state","value":"$","type":"string","structure":[]}],"settings":[],"collapsed":[{"name":"loop","isCollapsed":false}],"x":516,"y":1184},{"id":"141C7266-0BE9-4518-8512-7AE1FCB7AB50","type":"SnippetBlock","disabled":true,"name":"listCurrentSelections","displayName":"Qlik Cloud Services - List Current Selections","comment":"","childId":null,"inputs":[{"id":"99bc8380-2067-11ec-a0ee-c55177fde1d2","value":"c3b3d1d3-25f4-4e29-a5cd-f64b4f7cb2dd","type":"string","displayValue":"Training Reporting (c3b3d1d3-25f4-4e29-a5cd-f64b4f7cb2dd)","structure":{}}],"settings":[{"id":"blendr_on_error","value":"stop","type":"select","structure":{}}],"collapsed":[{"name":"loop","isCollapsed":false}],"x":1641,"y":747.9978493443791,"loopBlockId":"0BD3E2B6-E14E-4450-B8AB-1D1F7B415820","datasourcetype_guid":"61a87510-c7a3-11ea-95da-0fb0c241e75c","snippet_guid":"99b9b8f0-2067-11ec-baaf-9db1f5f660b2"},{"id":"2343A10C-D45A-4002-8D0F-317B29449903","type":"ShowBlock","disabled":true,"name":"output","displayName":"Output","comment":"","childId":null,"inputs":[{"id":"input","value":"{ $.listCurrentSelections.item }","type":"string","structure":{}}],"settings":[{"id":"display_mode","value":"add","type":"select","structure":{}}],"collapsed":[{"name":"loop","isCollapsed":false}],"x":-89,"y":689},{"id":"ACEB3418-0EE0-4D4A-9885-8A03708E2D7B","type":"QlikReportingCreateReportBlock","disabled":true,"name":"createReport2","displayName":"Evaluation Report - Create Report 2","comment":"Specify the app ID and report name. Set the sheets mode to All to include all public sheets in the report.","childId":null,"inputs":[{"id":"app_id","value":"c3b3d1d3-25f4-4e29-a5cd-f64b4f7cb2dd","type":"string","displayValue":"Training Reporting (c3b3d1d3-25f4-4e29-a5cd-f64b4f7cb2dd)","structure":[]},{"id":"name","value":"Evaluation Report","type":"string","structure":[]},{"id":"sheets_mode","value":"custom","type":"select","displayValue":"Custom","structure":[]}],"settings":[],"collapsed":[{"name":"loop","isCollapsed":false}],"x":1454,"y":701.9986613266035},{"id":"0BD3E2B6-E14E-4450-B8AB-1D1F7B415820","type":"QlikReportingAddSelectionToReportBlock","disabled":true,"name":"addSelectionToReport4","displayName":"Evaluation Report - Add Selection To Report 4","comment":"User Select\n","childId":"2343A10C-D45A-4002-8D0F-317B29449903","inputs":[{"id":"report","value":"62669A0D-175C-4269-B63F-9B25F74B36E9","type":"select","displayValue":"Create Report (Evaluation Report)","structure":[]},{"id":"field","value":"%user","type":"string","displayValue":"%user","structure":[]},{"id":"values","value":["{$.inputs.user}"],"type":"list","mode":"keyValue","structure":[]},{"id":"state","value":"$","type":"string","structure":[]}],"settings":[],"collapsed":[{"name":"loop","isCollapsed":false}],"x":1272,"y":788.9982992264222}],"variables":[{"guid":"8F720502-FDF3-4B08-8F2A-D455689D406C","name":"recipients","type":"list"},{"guid":"38591B0D-F820-4985-8816-57C29530E5E4","name":"template64","type":"string"}]}

Re: Apply multiple selection to the report

OlivierS — Tue, 04 Apr 2023 09:17:41 GMT

I try to respond to your message but the drag and drop system keeps kicking my json file from the reply 😞

Re: Apply multiple selection to the report

OlivierS — Tue, 04 Apr 2023 09:20:50 GMT

Re: Apply multiple selection to the report

Madhushree_BP — Tue, 04 Apr 2023 12:37:46 GMT

Hi @OlivierS ,

Are you trying to get selections applied on UI?
Can you use the List current selection block after the select field value blocks to get the selections applied to the report and also pass the values to Add selection to the report block, which should work in this case?
Please have a look at the example automation shared below which should work.

Please let me know your feedback.

Thanks,

Madhushree