topic Re: Visualize a specific sheet on open in QlikView

Visualize a specific sheet on open

Anonymous — Fri, 27 Dec 2013 16:01:25 GMT

Hi,

i have a project with multiple sheet published on a server.

Every time someone made the log in the project must start with the sheet called "Homepage".

I tried this but doesn't work

Settings Menu -> Document Properties -> Triggers -> Document Event Triggers (on Open) -> Add -> Layout -> Activate Sheet-> Give sheet name

Any suggestion?

I also have some field. Two of them are YEAR and MONTH. I'd like set them to the current date on project opening (in this case 2012 and 12). Is that possible ?

Re: Visualize a specific sheet on open

Nicole-Smith — Fri, 27 Dec 2013 16:04:42 GMT

You need to give the Sheet ID (right click on the sheet, then go to Properties > General to get the ID) instead of the name.

Re: Visualize a specific sheet on open

Anonymous — Fri, 27 Dec 2013 16:05:48 GMT

Luca

Some Triggers, especially 'On Open' Triggers do not work with the Ajax Web Client.

Best Regards, Bill

Re: Visualize a specific sheet on open

Nicole-Smith — Fri, 27 Dec 2013 16:07:53 GMT

For the date stuff, where is December 2012 coming from? Or did you mean December 2013?

If you want it set to the current month and year of today:

Settings > Document Properties > Triggers > On Open > Select in Field

YEAR

=year(today())

MONTH

=num(month(today()))

Re: Visualize a specific sheet on open

Anonymous — Fri, 27 Dec 2013 16:54:20 GMT

Doesn't work on my client project neither....

The selection of field value (nicole's answer) works but the selection of the sheet doesn't.
I put the identifier of the sheet, not the name.

Re: Visualize a specific sheet on open

Nicole-Smith — Fri, 27 Dec 2013 16:55:32 GMT

Did you put the full SH01 or just the number? You need the full ID.

Re: Visualize a specific sheet on open

Anonymous — Fri, 27 Dec 2013 17:02:49 GMT

i put SH01

Re: Visualize a specific sheet on open

Anonymous — Fri, 27 Dec 2013 17:12:23 GMT

i have understand the problem.

My homepage (SH01) have a conditional function.

It can be shown only if my variable "VisibleSheet" = 0

If i put

Settings > Document Properties > Triggers > On Open > Select in Field

VisibleSheet

in the same way of YEAR and MONTH doesn't work

Re: Visualize a specific sheet on open

Nicole-Smith — Fri, 27 Dec 2013 18:13:58 GMT

For a variable you need Settings > Document Properties > Triggers > On Open > External > Set Variable

VisibleSheet

Do not put =0, just 0.