Need help on section access

[soniasweety]

Hi all,

i want to implement the section access by region ..

i have a region field in Database 

Region

AMS

APJ

EMEA.

so  admin should see  3 regions data  and   who ever having the access for perticular region they should see respective region data.

im using below script but its not working as expected.

SECTION Access;

UserList:
LOAD 
     UPPER(ACCESS) AS ACCESS, 
     UPPER(NTNAME) AS NTNAME, 
upper(DATAFIELD) as REGION    
FROM
[..\data.qvd](qvd);

Concatenate
LOAD * Inline [
ACCESS, NTNAME, REGION
ADMIN, AUTH\$qv09, *
ADMIN, AUTH\$qv08, *

]; 
SECTION Application;

[Vegar · Accepted solution]

The star only include all values mentioned in the Section Access REGION-field. Adding the three users will allow your admins to see all three. 

SECTION Access;

UserList:
LOAD 
     UPPER(ACCESS) AS ACCESS, 
     UPPER(NTNAME) AS NTNAME, 
upper(DATAFIELD) as REGION    
FROM
[..\data.qvd](qvd);

Concatenate
LOAD * Inline [
ACCESS, NTNAME, REGION
ADMIN, AUTH\$qv09, *
ADMIN, AUTH\$qv08, *
USER, AUTH\AMSUser, AMS
USER, AUTH\APJUser, APJ
USER, AUTH\EMEAUser, EMEA

]; 
SECTION Application;

[cokiston]

Apologies if I am using your post for my question, is just that I couldn't find how to open a discussion in this page.

I need some help in QlikSense for the below scenario:

Column A contains an identifier that will be duplicate if an RT and GF Date exist, if only one exist then the Qlik sense table shows only 1, what I need is a formula for a column that will show the GF Date in the RT row and vice versa. is that possible??

Column A	Column B	Column C	Desired Column:
123456789	RT	12/13/2019	11/10/2018
123456789	GF	11/10/2018	12/13/2019
987654321	RT	1/4/2019	8/3/2017
987654321	GF	8/3/2017	1/4/2017

[soniasweety]

Hi Vegar  thanks for your response.

the way you given is working perfectly.  

but the user info we are getting as seperate qvd.  from there it will fetch ..now its working fine.