how to use section acess for Sheet (Report)

[geam1988]

Hi,

in 1 .qvw file. i have 10 report (Sheet) und 5 Document CAL(User) is there.  3 Document CAL (User) are allowed to see all the report. Other 2 user are allowed to see only 5 reports (Sheet).

Report shows allmost same data except expressions. Section access in document is not possible (will not work properly). Is it possible to use section access in Sheet or some other way to put restriction on some user ? so that they do not see all the report.

Best Regards

kazi

[Anonymous]

What you could do, is use the OSUSER command within a Conditional show option for the sheets.  That should do the trick.

Example for Conditional Show within the Sheet Properties:

=IF(OSUser() = 'company\username',0,1)

Just use the USERS Username's that you can see in the QMC (Qlikview Management Console)

[geam1988]

Hallo Greeff,

in Qlikview Management Console  name is like this ,

NTNAME is like this,

SATNT01\KOELSCH

SATNT01\WEBERT

i do not have section access in the .qvw

i want Mr. Lars to see all the report (Sheet) but i do not want Mr. webert to see  WM report (Sheet) .

i have used following expressions in  sheet conditions but it is not working.

=IF(OSUser() = 'SATNT01\Weber, Tobias',0,1)

=IF(OSUser() = 'SATNT01\WEBERT',0,1) 

=IF(OSUser() = 'SATNT01\WEBERT',0,'WM') 

Best regards

Kazi