Qlik Application Automation: PPT Export, Clear Selections & Looping over Field Values

[herard_bertrand]

Hi everyone,

I am currently building a Qlik Application Automation to export sheets from a Qlik Cloud app into a PowerPoint (PPTX) presentation. While the core export is working, I am looking for the best practices regarding selection management and data bursting.

Could you please point me in the right direction for the following points?

• 1. Clearing ALL selections: What is the exact block or standard method to completely clear all active selections in the source Qlik Cloud app before starting the report execution, ensuring a clean slate?

• 2. Clearing a SPECIFIC selection: During my bursting process, I need to clear a selection on one specific field without clearing the others. However, I cannot find a dedicated "Clear Selection" block in the current interface (I only see blocks like Add Selection to Report). Has this block been renamed/removed, and how do you handle specific field clearing today?

• 3. Looping over a field's values: What is the most robust block or approach to loop through all distinct values of a specific field (e.g., a "Region" dimension) so I can generate a customized slide for each value?

Any insights, exact block names, or architectural tips would be greatly appreciated!

Thanks in advance for your help.

[herard_bertrand]

Hello, 

thanks for your answer.

1) I don't see any "Clear All Selections" Block (even by using the search function). Where do you find it ? 

2) Ok, I don't manage to remove a selection on a field using a Add Selection to report box. I suppose we need to use a raw Input ?  But how to write "Empty" I tried several values including "" which doesn't work

Edit : this point is OK, I made a confusion between "Add Selection to Report" (all sheets) and "Add Selections to Sheets" (just one sheet)

3) I see no List Field Values block where do you find it ? 

When I read your answer (And I tried a few questions using a LLM). I suspect some Automation boxes disapeared recently or some boxes are hidden or somes boxes may miss on some tenant ? Is there any Admin settings/roles to activate to get all Automation boxes ?

Thanks