Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
toui
Partner - Contributor
Partner - Contributor

SECTION ACCESS

Hello,

I have an access problem for type ACCESS='USER'.
users have an 'access denied' error message.
On the other hand, when I change everyone to type ACESS='ADMIN' it works even with restrictions on the UG column (as in the example).
could you help me?
THANKS

toui_1-1679928267693.png

 

toui_0-1679928245451.png

 

Labels (1)
1 Reply
BrunPierre
Partner - Master II
Partner - Master II

Hi, all data loaded from an external data source must be uppercase within the section access statement.

Concatenate(Authorization)
LOAD Upper(ACCESS) as ACCESS,
            Upper(USERID) as (USERID),
  ---- <Others lines here>---