topic Re: how to use section acess for Sheet (Report) in QlikView

how to use section acess for Sheet (Report)

geam1988 — Tue, 09 Oct 2018 09:54:41 GMT

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

Re: how to use section acess for Sheet (Report)

Anonymous — Tue, 09 Oct 2018 10:01:32 GMT

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)

Re: how to use section acess for Sheet (Report)

geam1988 — Thu, 11 Oct 2018 14:39:10 GMT

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