Qlik Application Automation: PPT Export, Clear Selections & Looping over Field Values
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!
For Qlik Application Automation, the best practices are fairly straightforward: use the Clear All Selections block to reset the app state before execution, ensuring no residual filters interfere with your report. For clearing a specific field, there isn’t a dedicated “Clear Selection” block anymore — instead, you achieve this by re‑applying selections on other fields and omitting the one you want cleared, or by using the Set Selection in App block with an empty value for that field. For looping over field values, the most robust approach is to use the List Field Values block to retrieve distinct values (like all Regions), then wrap it in a For Each loop to iterate through them and generate slides per value. This combination gives you clean selection management and reliable bursting logic.
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 ?
