topic Re: How to apply filter when opening a sheet in QlikView

How to apply filter when opening a sheet

Fri, 18 Oct 2013 16:52:39 GMT

When I activate/open a sheet (SH16) using a button I would like a filter to be applied. In this case, the field name is [Strategic Priority Only] and the field value is "Yes". That is the only option for a field value.

I tried using the Action of Selection > Select in Field but it is not working.

Re: How to apply filter when opening a sheet

Clever_Anjos — Fri, 18 Oct 2013 16:56:00 GMT

Use trigger tab at "Sheet Properties"

Re: How to apply filter when opening a sheet

Fri, 18 Oct 2013 16:57:26 GMT

Go to Sheet Properties, Actions, Selections, 'Select in Field'

Re: How to apply filter when opening a sheet

Gysbert_Wassenaar — Fri, 18 Oct 2013 16:58:27 GMT

Did you assign that action to the OnActivate sheet trigger? If you want to select only the value "Yes" then the search string would be Yes without the quotes.

Re: How to apply filter when opening a sheet

jagan — Fri, 18 Oct 2013 17:00:37 GMT

Hi,

Please find attached file for solution. This is been implemented by using Sheet Properties -> Triggers -> On Activate Sheet -> Add

Please find attached file.

Regards,

Jagan.

Re: How to apply filter when opening a sheet

Anonymous — Fri, 18 Oct 2013 17:24:57 GMT

Sheet triggers don't work in WebView/AJAX. Why don't add the select action right there, in the button?