Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. $300 savings extended to February 9th Learn More
ksharpes
New Contributor III

Section Access QSR Wildcard issue

So I have the following code to determine my Section access for an Application, however it is not working as intended.

If I set the custom property to "ALL" in the QMC is is correctly recognized and changed to a *, however if ACCESS = USER it shows as "Access Denied" when they try to login,if the ACCESS = ADMIN it works as intended.

LIB CONNECT TO 'PostgreSQL_localhost';

[UserSecurity]:
LOAD Upper(Name) as ACCESS, Upper(UserDirectory & '\' & UserId) as USERID, If(Upper(Value)='ALL','*',Upper(Value)) as REDUCTION;
SQL Select "T"."Name", "U"."UserId", "U"."UserDirectory", "V"."Value"
From "public"."Users" "U"
inner join "public"."TagUsers" "TH" on "U"."ID" = "TH"."User_ID"
inner join "public"."Tags" "T" on "TH"."Tag_ID" = "T"."ID"
inner join "public"."CustomPropertyValues" "V" on "U"."ID" = "V"."User_ID" ;

Section Access;
Load
ACCESS,
USERID,
REDUCTION
Resident UserSecurity;


Section Application;