topic Re: Section Access in QlikView

Section Access

Mon, 05 Jan 2015 16:43:59 GMT

Hi All

I have a fully functional script which loads data from numerous sources and is working perfect.

However, I am now trying to add some section access script in. I am doing this in a hidden script.

I have a excel table with my users in and passwords and that looks like below:

ACCESS	USERID	PASSWORD	IBNRCLS2
USER	AFLOWER	2015	MTR
ADMIN	ALYNCH	1988	LIAB
USER	HFRANKLIN	2014	MTR

All i want my script to do is the following:

On Opening of the dashboard prompt for USERID & PASSWORD
When AL Logs in then only show results for LIAB which is a subfield under the Field IBNRCLS2

So my script looks like this

SECTION Access;

LOAD

ACCESS,

USERID,

PASSWORD,

IBNRCLS2

FROM

[QS:\Indemnity Performance\Functional - Claims Insight\Exception Reporting\Qlikview Testing\Andrew Data\Section Access Test\Passwords.xlsx]

(ooxml, embedded labels, table is Sheet1);

and my document properties look like this

Im having two problems with this.

Its not working. I is not prompting me for any USERID or Password and is not filtering the results
When i try to reload my script it fails saying that im missing a field from one of my tables which im not.

Can someone Help me please. I have read the document in relation to section access.

Also it is worth mentioning that I am using personal addition and not server.

Thanks

Andrew

Re: Section Access

isorinrusu — Mon, 05 Jan 2015 17:15:52 GMT

Hi there,

Do you close the Section Access code zone with SECTION Application?

Like this:

SECTION Access;

LOAD * INLINE [

NTNAME, ACCESS, ROL

'USERSAD\isorinru', USER, 'ROL DEMARCACION'

];

SECTION Application;

Regards,

Sorin.

Re: Section Access

manojkvrajan — Mon, 05 Jan 2015 17:21:06 GMT

Andrew,

Sorin's script should work. However, you may need to setup an additional PASSWORD field in your SECTION access script if you need an explicit password (without connecting to your Active Directory).

Link below should provide you good insight about SECTION access.

http://community.qlik.com/docs/DOC-5917

Re: Section Access

stevedark — Tue, 06 Jan 2015 00:39:57 GMT

Hi Andrew,

Which field is it saying is missing on reload? If it is one of the fields in the Section Access spreadsheet then that table will not load and effectively there will be no Section Access.

Section Access is very picky about field names. It is good practice to ensure that all field names and values appear in upper case; with IBNRCLS2 and LIAB it would appear you have this covered.

Not sure what you mean by a 'subfield under the field'. Is this a comma separated list or something? If so, you will need to split the values out into an associated table and do the section access on this.

The fact you are using Personal Edition should not have a bearing on whether Section Access works or not.

One last thing on Section Access, be aware you can lock yourself out of your own document. I would recommend reading this:

http://www.quickintelligence.co.uk/help-ive-locked-myself-out/

Hope that helps,

Steve

Re: Section Access

jagan — Tue, 06 Jan 2015 02:10:42 GMT

Hi Andrew,

Check below script for implementing Section Access in Qlikview, if this script is working then load data from your excel file instead of Inline load.

Note: The column names are case sensitive in Qlikview.

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, REDUCTION

ADMIN, Admin, password, *

USER, Sales, password1, 1

USER, Market, password1, 2

];

Section Application;

star is *;

Departments:

LOAD * INLINE [

REDUCTION, Dept,

1, Sales

2, Marketing];

Sales:

LOAD * INLINE [

Dept, Sales

Sales, 100

Sales, 200

Sales, 4646

Sales, 755

Sales, 422

Sales, 42

Marketing, 2

Marketing, 453

Marketing, 54

Marketing, 45

];

When you login as Admin, you can see all data in the dashboard, when you login as Sales then you can see only Sales data and when you login as Market you can see only Marketing data.

User and password details for this application is

User Name Password

Admin, password

Sales, password1

Market, password1

Note: You need to select Document Properties -> Opening tab -> and select Initial Data Reduction based on Section Access option

Hope this helps you.

Regards,

Jagan.