Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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:
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'.
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.
Do we know if this type of 'on demand' reporting is on the road map?
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:
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'.
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.
Hi @Vasujoshi_700 ,
I'm afraid I don't fully understand your request.
My previous post should address the following requirements:
Am I missing a requirement here or does that automation generate the wrong selections?
Thanks,
Emile
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.
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 🙂
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,
A.
Hey @Emile_Koslowski!
Same here, this automation has stopped to work ! 😞
I see error message: The automation did not receive the required inputs.
Hi,
Could you solve this issue?
Thanks!