topic Re: SECTION ACCESS in QlikView

SECTION ACCESS

manoranjan_d — Tue, 27 Jun 2017 11:53:01 GMT

sample data

CONTRACT	AMOUNT	QUARTER	FLAG
AAA	345	2016Q4	Y
BBB	7654	2017Q1	Y
CCC	9876	2017Q2	Y
DDD	765	2017Q3	N

admin has to see the all the flag details Y or N , but the contracts(users) has to see only the Y flag for the specific contract.

How to do this in the qlikview ?

i tried in the below way, but as per the admin level i can achieve it, but user level it getting failed its showing all records for all the users

hidden script:

SECTION Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, FLAG

ADMIN, ADMIN, ADMIN123, Y

ADMIN, ADMIN, ADMIN123, N

USER, AAA, AAA123, Y

USER, BBB, BBB123, Y

USER, CCC, CCC123, Y

USER, DDD, DDD123, N

];

SECTION Application;

main tab:

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 FirstWeekDay=6;

SET BrokenWeeks=1;

SET ReferenceDay=0;

SET FirstMonthOfYear=1;

SET CollationLocale='en-US';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';

T1:

LOAD CONTRACT, AMOUNT, QUARTER, FLAG

FROM (ooxml, embedded labels, table is Sheet1);

Re: SECTION ACCESS

felipedl — Tue, 27 Jun 2017 13:43:07 GMT

Hi Manoranjan,

See if this option is marked

Settings -> Document Settings -> Opening.

Felipe.

Re: SECTION ACCESS

manoranjan_d — Tue, 27 Jun 2017 14:19:40 GMT

yes given,

my only concern is if the flag is Y then it will show the contract details of all Y, example if I login as user of AAA, the it will show all the contract details, ineed only AAA contract details

CONTRACT	AMOUNT	QUARTER	FLAG
AAA	345	2016Q4	Y
BBB	7654	2017Q1	Y
CCC	9876	2017Q2	Y

Re: SECTION ACCESS

felipedl — Tue, 27 Jun 2017 17:54:55 GMT

If your logged as 'AAA', it will section the application according to the fields you inputed.

Add another field for it to section the application the way you want it.

Something like:

SECTION Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, FLAG,CONTRACT

ADMIN, ADMIN, ADMIN123, *,*

USER, AAA, AAA123, Y,CCC

USER, BBB, BBB123, Y,DDD

USER, CCC, CCC123, Y,BBB

USER, DDD, DDD123, N,AAA

];

SECTION Application;

in this case, it would section for both fields and so user 'DDD' would have access to contract 'AAA' and flag 'N'.

Felipe.