topic Re: Application automation Reporting in Reporting Service & Alerting

Application automation Reporting

Vasujoshi_700 — Fri, 19 Aug 2022 08:21:14 GMT

I want to make selections in the front end of the app and trigger a report by application automation with those selections from the front end. Any idea how can i accomplish that? Any kind of suggestion would be really help full.

Re: Application automation Reporting

Frank_S — Fri, 19 Aug 2022 15:03:00 GMT

You can create a button in the source app which when pressed, will take you out to the Automation.

However making selections then dynamically applying them to the report via this button does not appear possible.
Currently selections are made via the automation blocks and there do not appear to be automation apis to enable dynamic selections or selections made from the QS app.

Button "send top sales... by email"

Website url: is the link to the Qlik automation report

The app custom button takes you to the report where you need to press the 'run' button.

I suggest adding an 'idea' to our feature request site here in the meantime.

Ideas | Qlik Community

cc @Emile_Koslowski

Do we know if this type of 'on demand' reporting is on the road map?

Re: Application automation Reporting

Emile_Koslowski — Fri, 30 Sep 2022 10:48:48 GMT

Hi both,

I think you could actually already build this today with what's available in Qlik Application Automation. It's not easy but the following steps should work:

If you follow this article: Triggering an automation from aa button on a sheet, you'll be able to trigger an automation from the button and have the selections from your app available as a bookmark inside the automation.
You can then use the block Apply Bookmark to apply those selections in the Qlik Sense session of the automation.
You can then use the block List Current Selections to get a list of the selections in the bookmark.
You can then loop through that list from step 3 and add every single one of those selections to the report by using the blocks Add Selection To Sheet and Add Selection To Report from the Qlik Reporting connector.

I've made the below example:

You can find the exported JSON of the automation attached to this reply, import it as an automation by right-clicking in an empty automation and choosing 'Upload workspace'.

Re: Application automation Reporting

Vasujoshi_700 — Thu, 25 Aug 2022 08:20:38 GMT

Hi, Emile, it is really amazing work but when i trigger the button it generates the report with that bookmark selection only and its also generates the bookmark with the selection that i have selected before the trigger.

In order to achieve that I need to rename the bookmark with a name that is being used in application automation,

it still has not met the requirement of generating reports with the current selection on the dashboard.

Thank you so much for your help and effort.

Re: Application automation Reporting

Emile_Koslowski — Wed, 31 Aug 2022 08:50:44 GMT

Hi @Vasujoshi_700 ,

I'm afraid I don't fully understand your request.

My previous post should address the following requirements:

The report should be generated from within the Qlik Sense front-end
The report should contain the same selections as the app has in the front-end when the report is generated

Am I missing a requirement here or does that automation generate the wrong selections?

Thanks,
Emile

Re: Application automation Reporting

Emile_Koslowski — Wed, 31 Aug 2022 08:53:21 GMT

Now I think of it, feel free to add a Clear All Selections block from the Qlik Cloud Services connector before the Apply Bookmark block if you think any other (unwanted) selections could be active in the app.

Re: Application automation Reporting

OlivierS — Tue, 04 Apr 2023 12:04:14 GMT

Hey Emile,

Thanks for your feedback,

When i execute your script, if dimension contain multiple selection, only the last value is retained into the report.

How should I modify this loop to be sure each value of each dimension is contained into the bookmark ?

Thanks in advance 🙂

Re: Application automation Reporting

At203 — Tue, 16 May 2023 10:37:09 GMT

Hey @Emile_Koslowski !

Thank you, I have been using this automation for some months and it has been working well. Unfortunately, this month it failed and brings a message "unknown error" - I tried to fix it but did not work. I uploaded the JSON file again and tried to create everything from scratch, but it keeps failing. I have some sort of feeling that it could be Qlik bug 🙂 Could you please check out - is it working for you?

Best regards,

Re: Application automation Reporting

Viktors — Tue, 16 May 2023 15:46:52 GMT

Hey @Emile_Koslowski!

Same here, this automation has stopped to work ! 😞

I see error message: The automation did not receive the required inputs.

Re: Application automation Reporting

Mariana_Nunes — Tue, 21 May 2024 15:42:15 GMT

Hi,

Could you solve this issue?

Thanks!