Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am using below section access script, where A and B are the group names created.
We have a sheet, with show condition as -
=if(MAXSTRING({<GName=$(NTNAME)>}HGFlag)='Y',1,0)
For both the user group, the sheet is still visible, as the MAXSTRING is resulting in Y each time.
Can anyone please suggest, what is wrong with this.
Regards,
MK
no luck...
after going to few more post, i have done following changes, but still no luck.
I have used sum(HGF)>=1, but for any group the value is coming as 1.
Please assist.
Don't you need OsUser() rather than QvUser() when using NTNAME in the SA script?
MAXSTRING({<GName={"$(=OsUser())"}>}HGFlag)
Hi,
Instead of GNAME try using REDUCTION in both the tables and also do the below
Note: You need to select Document Properties -> Opening tab -> and select Initial Data Reduction based on Section Access option
Check this links for reference
Authentication and Authorization in Qlikview
Regards,
Jagan.
Thanks Jonathan for the correction.