topic Re: Section Access not working for field types in QlikView

Section Access not working for field types

matthewp — Wed, 14 Sep 2016 12:15:25 GMT

I cant get my section access to limit what a user can see within my qv document.

Excel file : section_access.xlsm

Tab name: SA

Data:

User/Admin	Name	NT logon	fieldtype
ADMIN	SVC_QV	server\svc_qv	<ALL>
ADMIN	John Doe	server\abc1	<ALL>
USER	Alan Smith	server\cde2	002
ADMIN	Administrator	server\administrator	<ALL>
USER	Paul Potts	server\fgh3	<ALL>

SECTION ACCESS SCRIPT:

SECTION Access;

trace <<< Section Access >>> ;

LOAD [User/Admin] as [ACCESS],

[NT logon] as [NTNAME],

[fieldtype] as [Field Type]

FROM

[Resources\section_access.xlsm]

(ooxml, embedded labels, table is SA)

;

trace <<< Section Application >>> ;

SECTION Application;

FIELD SCRIPT:

field:

LOAD [f ID],

[f Type] AS [Field Type],

[f Name] AS [Field Name]

FROM

$(vDetailsQVDDirectory)FIELD_LOAD.qvd

(qvd);

Re: Section Access not working for field types

Chanty4u — Wed, 14 Sep 2016 12:19:18 GMT

try with UPPER()

SECTION Access;

trace <<< Section Access >>> ;

LOAD [User/Admin] as [ACCESS],

UPPER( [NT logon]) as [NTNAME],

UPPER([fieldtype] )as [Field Type]

FROM

[Resources\section_access.xlsm]

(ooxml, embedded labels, table is SA)

;

trace <<< Section Application >>> ;

SECTION Application;

FIELD SCRIPT:

field:

LOAD [f ID],

UPPER( [f Type]) AS [Field Type],

UPPER[f Name] ) AS [Field Name]

FROM

$(vDetailsQVDDirectory)FIELD_LOAD.qvd

(qvd);

Re: Section Access not working for field types

matthewp — Wed, 14 Sep 2016 12:24:41 GMT

Still the same after reload, [Field Type] is a number if that makes any difference?

Re: Section Access not working for field types

jonathandienst — Wed, 14 Sep 2016 12:24:49 GMT

I am assuming that <ALL> means all items rather than a specific value of <ALL> in your fact table. You will need a generic key approach here. This article will help you Generic keys

Also the fields used in section access should all be in upper case, so you might need to rename [Field Type] to [FIELD TYPE]

Re: Section Access not working for field types

matthewp — Wed, 14 Sep 2016 12:29:50 GMT

Changed the Aliases to upper case and still the same

Re: Section Access not working for field types

Anil_Babu_Samineni — Wed, 14 Sep 2016 12:52:03 GMT

I Tried same thing. It's working perfect

ACCESS	NTNAME	SECURED_COMPANY	PASSWORD
ADMIN	ABC	ALL
ADMIN	DEF	A;B;C
ADMIN	GHI	A;D;F
USER	JKL	*
ADMIN	MNO	ALL
USER	PQR	ALL

Then Try Something like

Security:

NoConcatenate

LOAD ACCESS,

NTNAME,

SECURED_COMPANY,

PASSWORD

FROM

Path

(ooxml, embedded labels, table is Sheet1);

Try this

User/Admin	Name	NT logon	fieldtype
ADMIN	SVC_QV	server\svc_qv	ALL
ADMIN	John Doe	server\abc1	ALL
USER	Alan Smith	server\cde2	002
ADMIN	Administrator	server\administrator	ALL
USER	Paul Potts	server\fgh3	ALL

Re: Section Access not working for field types

stigchel — Wed, 14 Sep 2016 13:05:17 GMT

Have you checked the initial data reduction based on section access? It is in menu Settings\Document properties the opening tab