Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
manojkumargowda
Creator
Creator

Qliksense section access - Userids and groups in seperate rows

Hi Guys,

We are getting userids from one source and groups from another source.  And also we have to omit the fields based on group and we have to reduce data (COUNTRY) based on userids.

User A and B belongs to ITGROUP  and they should not see SALES field and USERA should only see COUNTRY=US data and USERB should only see COUNTRY=AUS. But Using below script, USERA can see both COUNTRY (US,AUS) data.

Section Access;
LOAD * INLINE [
ACCESS, USERID, GROUP, COUNTRY, OMIT
USER, *, ITGROUP, *, SALES
USER, *, SALESGROUP, *, IT
USER, CORPAU\USERA, *, US,
USER, CORPAU\USERB, *, AUS,
USER, CORPAU\USERC, *, IN,

];

User group mapping:

USER GROUP
CORPAU\USERAITGROUP
CORPAU\USERBITGROUP
CORPAU\USERCSALESGROUP
4 Replies
Anil_Babu_Samineni

You need to assign all the list either in single row If your restricted data has same group or Different row like

Section Access;
LOAD * INLINE [
ACCESS, USERID, GROUP, COUNTRY, OMIT
USER, Username, ITGROUP, *, SALES
USER, Username, SALESGROUP, *, IT
USER, CORPAU\USERA, *, US,
USER, CORPAU\USERB, *, AUS,
USER, CORPAU\USERC, *, IN,

];

 

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
ajaykakkar93
Specialist
Specialist

You can try this also,
LOAD * INLINE [
ACCESS,USERID, GROUP,COUNTRY,OMIT
USER,CORPAU\USERA,*,US,SALES
USER,CORPAU\USERB,*,AUS,SALES
USER,CORPAU\USERC,*,IN,
USER,CORPAU\USERC,SALESGROUP,*,IT
];
manojkumargowda
Creator
Creator
Author

Hi, Thanks for the response.

As I said before, I'm getting userid and group from 2 different source. I cannot keep both userid and group in single record. my script is more like below.

//Loading groups from source1

Section Access;
LOAD * INLINE [
ACCESS, USERID, GROUP, COUNTRY, OMIT
USER, *, ITGROUP, *, SALES
USER, *, SALESGROUP, *, IT

];

//Loading Userids from source2

concatenate

LOAD * INLINE [
ACCESS, USERID, GROUP, COUNTRY, OMIT
USER, CORPAU\USERA, *, US,
USER, CORPAU\USERB, *, AUS,
USER, CORPAU\USERC, *, IN,

];

Anil_Babu_Samineni

Section access File not need to test which source it has, Because This work index based on entire model side.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)