Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
Section Access;
LOAD
* INLINE [
ACCESS, USER.EMAIL, SPDI
ADMIN, MARK.ROEBUCK@PROVEPRIVACY.COM, *
USER, ASWATH.P@emvigotech.com, ONE
USER, SATHEESH.M@EMVIGOTECH.COM, *
];
Section Application;
The above section access script in Qlik Sense sheet is working fine, but I want to restrict data based on the 'id' column instead of 'SPDI'. However, my column name is in lowercase. How can I convert it to uppercase in the section access.
@Markbhai use the upper() function, it works like this:
LOAD
upper(user.email) as USER.EMAIL,
Hi @Markbhai ,
I Load 'id' column but i got 'Field not found' error I attached my data model and error screenshot please share your feedback.
My Current Section Access Script,
Load
Upper(ACCESS) as ACCESS,
Upper(USER.EMAIL) AS USER.EMAIL,
Upper(id) as ID
INLINE [
ACCESS, USER.EMAIL, ID
ADMIN, MARK.ROEBUCK@*********.COM, *
USER, ASWATH.P@*******.COM, 36
USER, SATHEESH.M@*********.COM, *
];
Section Application;