topic Re: Secton access in QlikView

Secton access

denis115 — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Secton access

Anil_Babu_Samineni — Wed, 06 Dec 2017 10:25:16 GMT

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

Re: Secton access

avinashelite — Wed, 06 Dec 2017 10:30:50 GMT

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

Re: Secton access

denis115 — Wed, 06 Dec 2017 10:34:23 GMT

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

Re: Secton access

Anil_Babu_Samineni — Wed, 06 Dec 2017 10:38:58 GMT

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

Re: Secton access

denis115 — Wed, 06 Dec 2017 10:41:40 GMT

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

Re: Secton access

denis115 — Wed, 06 Dec 2017 10:45:54 GMT

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

Re: Secton access

avinashelite — Wed, 06 Dec 2017 11:24:53 GMT

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

Re: Secton access

denis115 — Wed, 06 Dec 2017 12:05:35 GMT

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;

Re: Secton access

Anil_Babu_Samineni — Wed, 06 Dec 2017 12:07:46 GMT

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

Re: Secton access

neha_shirsath — Wed, 06 Dec 2017 12:14:41 GMT

First check you have enabled the setting in Document Properties tab > Opening > Initial data reduction....

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, PRODTYPE

USER, USER1 , WOOD

USER, USER2 , MEAT

USER, USER3,GOLD

ADMIN, USER4 , * //Here * means PRODTYPE listed below inline

];

Section Application;

load * inline [

PRODTYPE

WOOD

MEAT

GOLD

];

Re: Secton access

denis115 — Wed, 06 Dec 2017 12:29:18 GMT

nothing changed...

Re: Secton access

neha_shirsath — Wed, 06 Dec 2017 12:41:25 GMT

Check the attached file.

I'm using below code and it is working-

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, PRODTYPE

USER, USER1 , WOOD

USER, QV.SUPPORT6 , MEAT

USER, USER3, GOLD

ADMIN, ADMIN , *

];

Section Application;

load * inline [

PRODTYPE

WOOD

MEAT

GOLD

];

Re: Secton access

MK9885 — Wed, 06 Dec 2017 14:14:26 GMT

hidden script :

Star is *;

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, Сбыт Группа

USER, USER1 , WOOD

USER, USER2 , MEAT

USER, USER3,GOLD
ADMIN, USER4 , *
];
Section Application;

You are changing the field name from PRODTYPE to "Сбыт Группа" and the section access would look for PRODTYPE which is not available...change it to the new field name you've given?

And I gues you already know NTname is Domain name. Ex- Domain\User1 but not just User1.

Re: Secton access

denis115 — Fri, 08 Dec 2017 11:36:56 GMT

Problem is solved!

After closing and opening my qvw file, everything worked great!

Thank you!

Re: Secton access

Anonymous — Fri, 08 Dec 2017 11:39:32 GMT

Which solution u have used ,kindly mark it as useful so that , who are facing the same type of issue it will be useful for them

Thanks,