topic Section Access for different sheets in a document in QlikView

Section Access for different sheets in a document

Tue, 19 Oct 2010 11:21:54 GMT

I have my section acces loaded into the script, however I'd like to be able to write a simple conditional statement in each sheet property granting user acces. For example,

(Uid = '02154', Show(Sheet))

Is anyone aware of such a statement? Thanks

Section Access for different sheets in a document

Tue, 19 Oct 2010 11:58:32 GMT

You need to type in the following as a sheet-show-condition:

Uid = '02154'

Section Access for different sheets in a document

Tue, 19 Oct 2010 12:06:03 GMT

Thanks for the reply.

I have Uid declared in my script already (below).

I was thinking of going for something like this but obviously i'm lacking the correct syntax.

(if

(Uid) <> 'Ortho', RemoveSheet),

-------------------------------------------------------------------------------------------------------------

Load

[ACCESS]

[USERID]

As Uid

[PASSWORD]

OMIT

FROM

[\\PE...

Section Access for different sheets in a document

Tue, 19 Oct 2010 12:31:31 GMT

Select Sheet Properties -> General -> Under Show Sheet select Conditional and type the condition

Section Access for different sheets in a document

Tue, 19 Oct 2010 12:34:35 GMT

Thanks for that.

Any ideas what the condition would be in the syntax? Currently what I have is incorrect:

if (SUM(Uid)>='Ortho', Sheet.Visible)

Section Access for different sheets in a document

Tue, 19 Oct 2010 12:40:20 GMT

SUM(Uid)>='Ortho' would be enough under Conditional section

Section Access for different sheets in a document

Tue, 19 Oct 2010 12:51:57 GMT

Works fine now, thanks for that!