SECTION ACCESS

[manoranjan_d]

     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);

[felipedl]

Hi Manoranjan,

See if this option is marked

Settings -> Document Settings -> Opening.

Felipe.

[manoranjan_d]

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

i

[felipedl]

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, *,*

    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.