topic Re: set a variable when sheet is active in QlikView

set a variable when sheet is active

Thu, 02 Oct 2014 20:10:12 GMT

Hi experts.

I need set a variabe when the sheet is active for example I have te variable CAL with tree values M1,M2,M3

and I need by default M1, of cours permited selects the other values but when change the tab or open the

report by default in M1.

any idea?

best regards.

JonnyPoole — Thu, 02 Oct 2014 20:14:43 GMT

The sheets have an 'on activate' trigger and a 'on leave' trigger.

When users activate the sheet, you can use a 'set variable' action to set the variable.

When they leave you use the same action to alter the same variable accordingly.

The triggers are on the sheet properties / triggers tab.

m_woolf — Thu, 02 Oct 2014 20:15:15 GMT

Set an OnActivate trigger for each sheet that assigns the variable value

Thu, 02 Oct 2014 21:27:57 GMT

thanks a lot Friends.