Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Peony
Creator III
Creator III

Variables in Section Access

Hi All. I want to use variable in section access
I set variables in Hidden Script. And then bring them into section access part. For some reason this solution doesn't works. I can't login with User admin123.  Please help to understand how to use variables foe Section Access.


 

Set Access = 'ADMIN';
Set UserID = 'admin123';
Set Password = '12345';


Section Access;
Star is *;
Access:
Load * Inline [
ACCESS, USERID, PASSWORD
ADMIN, demo, demo123
];

Concatenate (Access)
Load
'$(Access)' as ACCESS,
'$(UserID)' as USERID,
'$(Password)' as PASSWORD
AutoGenerate(1);

Concatenate (Access)
Load
ACCESS,
USERID,
PASSWORD
Resident
Access_List;

Section Application;

 

Labels (1)
1 Solution

Accepted Solutions
MayilVahanan

Hi

All values must be in UPPER Case,  can you change and try once.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

2 Replies
MayilVahanan

Hi

All values must be in UPPER Case,  can you change and try once.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Peony
Creator III
Creator III
Author

Thank you @MayilVahanan  
Your advice helped!