topic Re: Create an report with two variable selections and send to ppt in Qlik Automate

Create an report with two variable selections and send to ppt

kbd — Wed, 29 Nov 2023 10:22:12 GMT

I am struggling with an automation where I want to create a monthly report and send to PowerPoint

I have two fields I want to select - The Month and the Bucket

the month is a field = 'Nov 23" and the Bucket has 1-100, 100-200, 200-300. I only want the Bucket 1-100 and 100-200

I am able to select one field with a variable and also able to send the report to PowerPoint but not use a second variable "bucket" with two bucket selections. I hope someone can help me. Thanks in advance

Re: Create an report with two variable selections and send to ppt

F_B — Thu, 30 Nov 2023 15:20:17 GMT

Hi Kbd,

I guess you select the month with the "Add selection to report" block.

You can add a second block "Add selection to report", choose the "field name" (bucket) and then "values" (1-100), after that with the button "+ Add value" you can add a second one (100-200). Isn't it working like this?

Re: Create an report with two variable selections and send to ppt

kbd — Tue, 05 Dec 2023 09:13:12 GMT

Hi, Partly got it to work but used another solution which is not as good as I want. I used an apply bookmark which gives me what I want but I would like to have it more dynamic and select from app and get the bookmark I have chosen. I only want to create one automation but the "Nov 2023" can change buckets as well. Is the only soluton to do several automations or do you have another idea. Thanks for the answer!

Re: Create an report with two variable selections and send to ppt

F_B — Wed, 13 Dec 2023 14:41:06 GMT

Not sure if you can link a Variable block of the automation to a variable input in the app... I'll have to study more!

Re: Create an report with two variable selections and send to ppt

panosalexand — Wed, 13 Dec 2023 21:15:42 GMT

Could you please send a screenshot how it's now ?