topic Re: Filters not affect one report. in Qlik Automate

Filters not affect one report.

Ns7703 — Wed, 25 Sep 2024 04:13:40 GMT

I want to ask , if there are 10 sheets in one qlik application and I have applied filters in all the sheets , so that prefiltering applied in all the reports at the same time . I want prefiltering in all the reports. But I dont want prefiltering in one report .Eg - if I am applying filter 'fiscal year-2020' ,all the reports prefiltered with fiscal year 2020,but I don't want 1 sheet to be prefiltered like other others. How to do that?

Re: Filters not affect one report.

AfeefaTk — Tue, 01 Oct 2024 08:55:30 GMT

Hi @Ns7703

You can filter the sheets based on the sheet title/id, and apply the selection to those sheets using the Add Selection to Sheet block.

Please find the example automation attached below.

Hope this works for you.

Thanks