topic activate sheet only after first selection in QlikView

activate sheet only after first selection

kristof_j — Fri, 02 Mar 2018 19:38:00 GMT

I want to make a search box with 3 fields.

If you select something in field 1, 2 or 3 you go to the respective sheet 1, 2 or 3. But once you're on the sheet and you select in another field, it shouldn't activate that sheet anymore.

e.g. you search something from field 1 and after selection, it activates sheet 1. If you then select something from field 3 it should activate sheet 3 anymore.

Is it possible?

If you use the Field Event Triggers (document properties) to activate Sheet X after a selection in Field X it won't stop 😞 it will always go to sheet X.

Any solutions?

Re: activate sheet only after first selection

vamsee — Fri, 02 Mar 2018 21:23:52 GMT

Hello,

I would suggest you create 3 duplicate fields of Duplicate_Field1, Duplicate_Field2, Duplicate_Field3 in the script.

Create triggers based on these three in the landing page.

In all other pages do not display them.

Hope it suits your need.

Thanks

Vamsee

Re: activate sheet only after first selection

kristof_j — Sat, 03 Mar 2018 19:51:49 GMT

I was thinking the same. The problem is that it aren't 3 dimensions like in my example but > 10 and potentially more. I'm trying to find a more efficient way.

Re: activate sheet only after first selection

sebastiandperei — Sun, 04 Mar 2018 00:38:57 GMT

Hi kristof.

Create a variable, for example, called "FirstSelection". Create a doc trigger that set it to 0 when the doc opens.

Add a second action to the triggers of these fields that set FirstSelection=1. Take in mind that these action must be below to Activate sheet action.

Finally, in Activate sheet action, make the condition to these variable for the name of the sheet:

if(FirstSelection=0, 'SH01'). This action MUST be before to set the variable.

Re: activate sheet only after first selection

kristof_j — Mon, 05 Mar 2018 07:35:53 GMT

I found the exact same solution