topic Applying all filters with one button in QlikView

Applying all filters with one button

Wed, 24 Oct 2012 18:59:00 GMT

I'm trying to have one sheet with all of our report filters, that drives all the other sheets in the report. Due to the size of the report, I would prefer for the report to not run on each filter selection. Is it possible to trigger all the filter selections on the hit of one button? This would prevent the report from running on every selection and increase the overall efficiency.

Thanks,

Re: Applying all filters with one button

whiteline — Wed, 24 Oct 2012 19:07:30 GMT

Hi.

You could save a bookmark and then create a button with an action that applys this bookmark.

Also you can hide that bookmark from users.

Re: Applying all filters with one button

Wed, 24 Oct 2012 19:26:51 GMT

Thanks, but unfortunately the filters will change each time. There are multiple users, running multiple variations of the report. Each variation would require it's own bookmark using this method, I believe.

Re: Applying all filters with one button

Wed, 24 Oct 2012 19:27:11 GMT

Re: Applying all filters with one button

whiteline — Wed, 24 Oct 2012 19:33:06 GMT

In the same way you can create actions for complex field selections.

It's possible to assign a sequence of actions to the button.