topic Re: Sheet Trigger in QlikView

Sheet Trigger

Sat, 22 Feb 2014 11:37:18 GMT

Hi, Experts .

Suppose i have 10 Sheets In my Dashboard. while i executing that last 3 sheets not to execute,i want to execute only first 7 sheets.

Is there method to do this please help me.

Re: Sheet Trigger

MK_QSL — Sat, 22 Feb 2014 12:01:16 GMT

Go to sheet properties and under Show Sheet Conditional write 1 = 2

Re: Sheet Trigger

Sat, 22 Feb 2014 12:20:24 GMT

what do u mean by "executing" Exactly

Re: Sheet Trigger

Anonymous — Sat, 22 Feb 2014 12:29:52 GMT

Go to sheet properties and under Show Sheet select Conditional and write condition so sheets are disabled.

or use section access for sheet security Sheets Security with Section Access, if you want certain users should have access to sheets or not.

Re: Sheet Trigger

maxgro — Sat, 22 Feb 2014 12:35:35 GMT

if you're referring to user interface sheets (hide sheets) as Manish already said

in Sheet Properties --> General tab --> Show Conditional --> 0

if you're referring to script (execute tab script) you can use

exit script;

at any point in your script to not execute the following script tabs

Re: Sheet Trigger

sundarakumar — Sat, 22 Feb 2014 16:58:34 GMT

use

exit script;

at the end of seventh sheet (i guess u r talking about script editor tabs).

-Sundar

Re: Sheet Trigger

aveeeeeee7en — Sat, 22 Feb 2014 17:25:36 GMT

Hi Shan

As Sundarakumar said i also think that you are talking about Script Tabs.

Kindly see the Attached Images.

Hope this will help you.

Regards

Aviral Nag

Re: Sheet Trigger

Sun, 23 Feb 2014 04:01:31 GMT

Hi, Executing means that when i do any selection in sheet1/2/3... It automatically reflect all the sheets and selection will happen. But i want to restrict the selection in the Last 3 sheets.

Re: Sheet Trigger

simsondevadoss — Sun, 23 Feb 2014 05:13:18 GMT

Hi Shan,

In last 3 sheets, Go to sheet properties-> triggers->on activate sheet(add actions)-> clear all.

So that your selection will not get reflected in those sheets.

Hope this helps.

Thanks,

Simson

Re: Sheet Trigger

marchoctober — Sun, 23 Feb 2014 07:20:36 GMT

You could also use possible solutions depends on your task, f.e. we are using alternate states.

If you have no state go to Document Settings General > Alternate states button, and add some state.

Further sheet properties at the top choose that state.

Further everything you do in this state will reflect only those objects and sheets that are in same state, esle it will reflect to default states.

I repeat, depending on your task there are a lot of variants and options to perform.

Re: Sheet Trigger

Sun, 23 Feb 2014 07:53:44 GMT

if u want Restrict Selection in last 3 Sheet then

go to sheet properties select trigger on sheet activation then clear all Selection

in this 3 sheet u have to do same things

by this way u can achieve desired result

hope this helps

Re: Sheet Trigger

agilos_mla — Sun, 23 Feb 2014 08:01:33 GMT

Alternate states is the best solution in your case. It's flexible since it allows eithet to disregard all selections in the other others or to combine some selections with specific in the 3 sheets.

I advise you also to use button to copy/transfer states (import/export selections between sheets)

HTH,

Michael

Re: Sheet Trigger

marchoctober — Sun, 23 Feb 2014 10:48:25 GMT

Thanks!

Yes, Alternate states is very flexible solution.

Re: Sheet Trigger

Mon, 24 Feb 2014 03:57:31 GMT

Thank You ALL TO HELP ME.