Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Problem is solved!
After closing and opening my qvw file, everything worked great!
Thank you!
You need to understand the usage of ACCESS .. Why Can't you try with USER then instead ADMIN??
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
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
Would you mine, Can you read this QlikView Section Access Examples
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
i've seen this before but Im using all good I think, thats why I'm here with this question
share you complete script and did you check the option which I told you in the last reply
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;
Will look, If you make Mockup to test with Username and Password