New to Qlik Sense

[manojkumargowda]

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\USERA	ITGROUP
CORPAU\USERB	ITGROUP
CORPAU\USERC	SALESGROUP

[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,

];

[ajaykakkar93]

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]

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.