Aletrnative of MAXSTRING

[Anonymous]

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

[Anonymous]

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.

[jonathandienst]

Don't you need OsUser() rather than QvUser() when using NTNAME in the SA script?

MAXSTRING({<GName={"$(=OsUser())"}>}HGFlag)

[jagan]

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

Sheet level access

Regards,

Jagan.

[tresesco]

Thanks Jonathan for the correction.