topic Re: Section access in QlikView

Section access

Wed, 17 Dec 2014 08:23:28 GMT

Hi,

why when I run my script can I then not see any data? Even though I have set my access as admin, everything disappears!

The data definitely loads into the file, so it's not a question of it not being there.

I am GLOBAL\A_MCLEOD

ACCESS	NTNAME	OMIT
ADMIN	GLOBAL\A_MCLEOD
USER	GLOBAL\USER1	R_Comments__c
USER	GLOBAL\USER2	e_comments__c
USER	GLOBAL\USER3	R_Comments__c

Section Access;
Sections:
LOAD
ACCESS,
NTNAME,
OMIT
FROM
[..\..\Section Access\SalesforceSectionAccess.xls]
(biff, embedded labels, table is [Sheet1$]);

Re: Section access

Wed, 17 Dec 2014 08:26:08 GMT

User * in place of blank OMIT and check

Re: Section access

tresB — Wed, 17 Dec 2014 08:30:08 GMT

Section Access loads table as a temporary table which is droped automatically. hence, you can't see it. If you want a table to be visible, load it under Section Application.

Re: Section access

Wed, 17 Dec 2014 08:30:14 GMT

Try inserting something into admins omit field. If the data loads, only the omitted field not, then QV has some problem with understanding the blank field.

Let us know what you have experiencd!

Best,

Re: Section access

Wed, 17 Dec 2014 08:46:21 GMT

This will not work, as * means the fields listed in the OMIT column will mean R_comments__c and e_comments__c will be unavailable to me

Re: Section access

Wed, 17 Dec 2014 08:51:59 GMT

And what if I have numerous tables following the Section Access table?

Do i simply need to put one preceding statement

Section Application;

Re: Section access

Wed, 17 Dec 2014 08:52:08 GMT

* does not mean the field in the list, it is to get access to all the values in the field

Re: Section access

Wed, 17 Dec 2014 09:12:05 GMT

Oh OK. I was only going of this doc

On page 17 it says

USER5 has a “*” added which means that all listed fields in OMIT will be unavailable.

USER5 will not be able to see fields SALES, WAREHOUSE and EMPLOYEES.

Note the admin user has nothing in the OMIT column

Re: Section access

tresB — Wed, 17 Dec 2014 09:19:12 GMT

Section access table is something that is uasually not desirable to be visiable by the users. If you take the same table under section application as well, it will be visible (Ctrl+T) to the users. Preceding load(under section application) might not be able to fetch data from section access.

Re: Section access

simenkg — Wed, 17 Dec 2014 09:26:50 GMT

The documentation is correct. * means all listed values in the field and not all possible values in the field.

Re: Section access

Wed, 17 Dec 2014 10:23:59 GMT

Yeah, that's what i thought.