topic Re: Need help on section access in QlikView

Need help on section access

soniasweety — Sat, 16 Nov 2024 03:52:58 GMT

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;

Re: Need help on section access

Vegar — Thu, 11 Apr 2019 21:38:11 GMT

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;

Re: Need help on section access

cokiston — Thu, 11 Apr 2019 22:03:45 GMT

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

Re: Need help on section access

soniasweety — Tue, 16 Apr 2019 15:27:01 GMT

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.