Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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.
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
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.
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.
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
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.