Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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