Secton access

[denis115]

hello!

I need your help!

I've tryied a script to give access to each person for different prodtype

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME,  PRODTYPE

    ADMIN, user1, JOB

    ADMIN, user2 ,HOME

];

Section Application;

but when I reload my file ,there are no changes, each of this two admins can see both PRODTYPES

help me please!

[Anil_Babu_Samineni]

You need to understand the usage of ACCESS .. Why Can't you try with USER then instead ADMIN??

[avinashelite]

have you enabled the strict exclusion in the Settings> document properties > Opening >Initial Data Reduction based on Section Access

and then do you have the PRODTYPE in your data set ? then it should work  and have all the user name in upper case 

[denis115]

If you mean like this :

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME,  PRODTYPE

    user, user1, JOB

    user, user2 ,HOME

];

Section Application;

it also doesnt worked for me

[Anil_Babu_Samineni]

Would you mine, Can you read this QlikView Section Access Examples

[denis115]

what do you mean about data set? of course I have all prodtypes in my tables and table 'PRODTYPE ' is shown on my first page of my file. The problem is when a person how opens qvw must see only one prodtype for which he is responsable

[denis115]

i've seen this before but Im using all good I think, thats why I'm here with this question  

[avinashelite]

share you complete script and did you check the option which I told you in the last reply

[denis115]

yes I did !

select
PRODID,
PRODTYPE AS  "Сбыт Группа",
PRODTYPE3 AS  "Сбыт Направление",
PRODNAME AS  "Наименование Продукта",
AT2NAME AS  "Товарная Группа",
AT3NAME AS  "Товарная Подгруппа",
AT5NAME AS  "Бренд" ,
NOMENCLATURE_STATUS_ID AS  "Статус ИД ТМЦ"

FROM VBNZ.PRODUCTS
where MODIFIED>='01.JAN.2016'
;

hidden script :

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, PRODTYPE
  
USER, USER1 , WOOD

USER, USER2 , MEAT

USER, USER3,GOLD
ADMIN, USER4 , *


];
Section Application;

[Anil_Babu_Samineni]

Will look, If you make Mockup to test with Username and Password