Section Access in Qliksense

[Anonymous]

Hi All,

I am trying to Implement Section Acess in Qliksense

My Requirement is when user will be login. You will be able to see particular location

Whatever i have mentioned in the script .

But it's not coming

Iam using below script . Please help on this

Script:

section access;

LOAD * inline [

ACCESS, USER DIRECTORY,ENGAGEMENT_WORK_LOCATION

USER, PROLIFICS\TMOTARWAR,CROWN PLACELONDON

];

[Anonymous]

Thanks a lot . For Quick reply can you please tell me how to add section Acess

[MK9885]

Ok but is it your network id?

Can you please get your exact network id by creating a text object inside n app and type in

=OSUser()

This would give your network ID and use that in USERID

[jagan]

Hi,

If it is NT ID use NTNAME instead of USERID

Section access;

LOAD * inline [

ACCESS, NTNAME ,ENGAGEMENT_WORK_LOCATION

USER, INTERNAL\SA_SCHEDULER,

USER, PROLIFICS\TMOTARWAR,CROWN PLACELONDON

];

Section Application;

[agigliotti]

please use the code below:

---

SECTION Access;

LOAD * inline [

ACCESS, USERID, %ENGAGEMENT_WORK_LOCATION

USER,PROLIFICS\TMOTARWAR,CROWN PLACELONDON

USER,INTERNAL\SA_SCHEDULER, ALLVALUES

];

STAR IS '*';

Section Application;

Load * inline

[

%ENGAGEMENT_WORK_LOCATION,Engagement_Work_Location

CROWN PLACELONDON,CROWN PLACELONDON

ALLVALUES, *

];

STAR IS;

---

Be sure you have "CROWN PLACELONDON" value in "Engagement_Work_Location" field in your data model, else you'll get access denied.

Let me know.

[Anonymous]

Hey yes CROWN PLACELONDON" value in "Engagement_Work_Location" field in my  data model,

[Anonymous]

Buts  CROWN PLACELONDON is in the Small letter . After Putting above code. Showing Acess Denied

[Anonymous]

Hi Jagan . Thanks For Reply Still Iam getting Same result . Thanks for help & Quick Reply

I have used your above code . But getting same result

[shraddha_g]

Use Upper(Engagement_Work_Location) instead of Engagement_Work_Location in your Data Model

[agigliotti]

both values have to match, otherwise your filter doesn't works.

[Anonymous]

Yes both value are same .but still not getting result