What is the difference between OSUSER() and NTNAME in qlikview?

[ananyaghosh]

hi,

I want to use section access in my application. I want that a particular user cannot see some object and some particular user will not see some data. How how can I implement this in QlikView?

I have 'CountryID' field and I want that when SANDIP will logged in he can see 1 and when admin logged in he will see all the listed values.

For data reduction I have used the following script:-

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, %CountryID

    ADMIN, ADMIN, ADMIN123, *

    USER, SANDIP, SANDIP123, 1

];

Section Application;

LOAD * INLINE [   

    %CountryID, CountryID

    1, 1

    2, 2

    3, 3

];

But for both user I am viewing all the countryid in the list box.

Thanks,

Sandip Ghosh

Message was edited by: Sandip Ghosh

[swuehl]

Just have a look into the sample I've attached above.

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, %COUNTRYID

    ADMIN, ADMIN, ADMIN123,

    USER, SANDIP, SANDIP123, 1

];

Section Application;

LOAD * INLINE [  

    %COUNTRYID, CountryID

    1, 1

    2, 2

    3, 3

];

[ananyaghosh]

Ok,Then I have to use %COUNTRYID as a reference field in section access area in script. Otherwise it wil not work. Right?