Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
kbd
Employee
Employee

Create an report with two variable selections and send to ppt

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

 

Labels (2)
4 Replies
F_B
Creator
Creator

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?

kbd
Employee
Employee
Author

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!

F_B
Creator
Creator

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!

panosalexand
Creator
Creator

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