topic Section Access in QlikView

Section Access

Wed, 18 Sep 2013 11:59:00 GMT

Hi,

I am new to qlikview and just started reading about section access in qlikview.I am unable to undeerstand why and what we write within

Section Application; and I am unable to understand the purpose of using the line star is *;.

Can anyone let me know about the same.It would be more helpful if someone can provide me with a sample application which would explain the same I did go through the introductory pdf put up in the community but could not gain much from it

Re: Section Access

Wed, 18 Sep 2013 12:03:06 GMT

* symbol stand for All.

Section access is used for security purpose of application and also hide the data for particular user.

see attached file.

Re: Section Access

israrkhan — Wed, 18 Sep 2013 12:06:08 GMT

Hi,

Read the attached document,

it will give you complete understanding with an easy example.

if any question or confusion, kindly ask...

Re: Section Access

Thu, 19 Sep 2013 04:45:08 GMT

hi,

I read the attached document,but still could not understand the code written within section application; section in the example 5 neither i am i able to understand why star is *; line and the code written within Section Application; is written in the below example.Can you please help me with the same I got the below example from

http://www.resultdata.com/qlikview-section-access-and-document-authorization/ link

SET ThousandSep=’,';
SET DecimalSep=’.';
SET MoneyThousandSep=’,';
SET MoneyDecimalSep=’.';
SET MoneyFormat=’$#,##0.00;($#,##0.00)’;
SET TimeFormat=’h:mm:ss TT’;
SET DateFormat=’M/D/YYYY’;
SET TimestampFormat=’M/D/YYYY h:mm:ss[.fff] TT’;
SET MonthNames=’Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec’;
SET DayNames=’Mon;Tue;Wed;Thu;Fri;Sat;Sun’;

star is *;

Section Access;
SATABLE:
LOAD
ACCESS,
NTNAME,
SAUSER
FROM
AppConfig.xlsx
(ooxml, embedded labels, table is App1);

Section Application;

DocSecurity:
LOAD
SAUSER,
TABACCESS.SHEET1,
TABACCESS.SHEET2,
FIELDACCESS.DIVISIONFILTER as Division
FROM
AppConfig.xlsx
(ooxml, embedded labels, table is App1);

FACTTABLE:
LOAD * INLINE [
Division, Date, Product, ProductSku, Qty, Amt
North, 01/10/2009, Widgets 1, ABCD-1234, 52, 220.0097
South, 01/10/2009, Widgets 1, ABCD-1234, 52, 220.0097
South, 01/11/2009, Widgets 2, EFGH-1234, 10, 120.0000
];

Re: Section Access

tresB — Thu, 19 Sep 2013 04:55:55 GMT

STAR keyword is used to represent set of all values in a field. Once it is defined like you did (Star is *), then in the following load if you mention * for any field, it would consider all values. By default, If nothing is specified, star is; is assumed, i.e. there is no star symbol available unless explicitly specified. Hope this helps.