Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
In my qliksense application, i ahve taken binary load of a file and then implemented section access but it is not working as expected. Am i missing anything?
Thanks,
Nikhil Garg
Check available fields for SA in Qlik Sense They're different to QlikView...
Link to help provided earlier
There is no NTNAME anymore
//Andrei
Hello,
Could you give more details on what's not working exactly?
User access? Data reduction?
It could whatever, so you definitely missing something.
//Andrei
When i am logging in on access point, it is asking me for credentials. When i am enetring my credentials(as ADMIN), it is giving error "Access Denied"
I have written following script:
Section Access;
LOAD
upper("Access") as ACCESS,
upper(NTNAME) as NTNAME,
upper(Region) as REGIONCODE;
SQL SELECT "emp_code",
"emp_fname",
"emp_lname",
"emp_Emailid",
Status,
"emp_password",
"Access",
NTNAME,
Role,
Region
FROM "QlikSense".dbo.LoginMaster;
Section Application;
LOAD
REGIONCODE,
SALES
FROM [lib://Desktop (abcd)/SectionAccess.xlsx]
(ooxml, embedded labels, table is Sheet1);
Are you including DOMAIN\ both in SA and when entering credentials?
Have a look into https://help.qlik.com/en-US/sense/February2018/Subsystems/Hub/Content/Scripting/Security/manage-secu...
USERID | Contains a string corresponding to a Qlik Sense user name. Qlik Sense will get the login information from the proxy and compare it to the value in this field. |
Hope this helps
/Andrei
Yes, my domain name is included in NTNAME
Check available fields for SA in Qlik Sense They're different to QlikView...
Link to help provided earlier
There is no NTNAME anymore
//Andrei
Thanks, this helps