topic Section access issue in QlikView

Section access issue

Wed, 25 Nov 2020 16:16:04 GMT

Hi I'm wondering if someone can help me , I'm trying to create a section access which restricts the data based on the account manager:

I'm using the following approach and after I reload save and reopen the application its not allowing me access, can anyone tell me where am I going wrong ?

Section Access;

LOAD
   'USER' as ACCESS,
    NTNAME,
    if( UPPER(OSUSER())='CLARANET/SARAH.ROBERTSON','SARAH ROBERTSON',''TEST' ) as ACCOUNT_MANAGER
FROM
[..\..\..\Master_Qlikview_Access.xlsx]
(ooxml, embedded labels, table is Sheet1)
Where [UK_Sales_Data_Dashboard]>0;

Section Application;

Account_Manager:

Load * Inline [

NO, ACCOUNT_MANAGER

1, SARAH ROBERTSON
2, SEAN LEIPER

];

Exit Script;

In the application under document properties, opening tab, I've selected - Initial Data Reduction Based on Section Access and Strict exclusion

Re: Section access issue

avinashelite — Thu, 12 May 2016 10:27:11 GMT

does the NTNAME matching the system name your working ?? is its not matching then you will be not able to open the file

Re: Section access issue

marcus_sommer — Thu, 12 May 2016 10:29:55 GMT

I would uncomment the Section Access; to see how the data within the table look like and would also add at least one ADMIN user maybe in concatenating a small inline-table.

- Marcus

Re: Section access issue

Thu, 12 May 2016 10:30:11 GMT

Hi Avinash,

Thanks for helping, yes I did a test on the section access without the data restriction selected and it allows me to access it . I think somehow with the data restriction its preventing me getting in somehow

Re: Section access issue

avinashelite — Thu, 12 May 2016 10:39:10 GMT

try like this ...without data restriction login to dashboard and add a text object then try this expression

=OSUSER() this will give you the info about the OSUSER details ...based on the user name add the data accordingly and then you could test the app ...

Hope this helps you

Re: Section access issue

Thu, 12 May 2016 10:41:31 GMT

Thanks for suggestions , I've tried commenting out the section access to look at the data its applying the correct ACCOUNT_MANAGER to the user, I've used the following script:

Section Access;

LOAD
'USER' as ACCESS,
NTNAME,
if(NTNAME='CLARANET\SARAH.ROBERTSON','SARAH ROBERTSON','AARON SMITH') as ACCOUNT_MANAGER
FROM
[..\..\..\Master_Qlikview_Access.xlsx]
(ooxml, embedded labels, table is Sheet1)
Where [UK_Sales_Data_Dashboard]>0;

Section Application;

Account_Manager:

Load * Inline [

NO, ACCOUNT_MANAGER

1, SARAH ROBERTSON
2, SEAN LEIPER

];

Exit Script;

after I reload and open the document im still getting this error message :

Re: Section access issue

Thu, 12 May 2016 11:12:07 GMT

yeah I've tried again its definitely something to do with the restricting selection based on section access. If I just use the section access I can access it no problem. any ideas ?

Re: Section access issue

marcus_sommer — Thu, 12 May 2016 11:12:30 GMT

Here a few suggestions:

Star is *;

Section Access;

Access:

LOAD
'USER' as ACCESS, upper(NTNAME) as NTNAME,
replace(subfield(UPPER(NTNAME), '\', 2), '.', ' ') as ACCOUNT_MANAGER
FROM [..\..\..\Master_Qlikview_Access.xlsx] (ooxml, embedded labels, table is Sheet1)
Where [UK_Sales_Data_Dashboard]>0;

concatenate(Access)

Load * Inline [

ACCESS, NTNAME, ACCOUNT_MANAGER

ADMIN, CLARANET/SARAH.ROBERTSON, *

];

Section Application;

Account_Manager:

Load * Inline [

NO, ACCOUNT_MANAGER

1, SARAH ROBERTSON
2, SEAN LEIPER

];

Exit Script;

As ADMIN you should take your user for server-services and some of of your developer-users.

- Marcus

Re: Section access issue

Thu, 12 May 2016 11:13:26 GMT

Oh it seems to have worked !! thanks guys