Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QSense
Contributor II

section access

Hi ,

I have a problem with section access Im doing with this excel file

In excel file ,in groups section,

GroupMUHASEBEGELIR YONETIMIURETIM PLANLAMA  REZERVASYON 
All1111
Group11000
Group21110

there are tab names such as MUHASEBE,GELIR YONETIMI..

and group name

and in other sheet(Section access) there are information below

USERNTD_EBI\S_SAGLAMAll
USERNTD_EBI\M_HAPCIOGLUGroup1
USERNTD_EBI\A_METIN2All
USERNTD_EBI\A_KONARGroup1

this method unfortunately does not work

My script below.

Group: //Exceldeki Section Access sayfasından kullanıcı ve grupları yüklüyoruz.

LOAD NTNAME as User,

[GROUP] as Group

FROM

CARGO_Yetkilendirme.xlsx

(ooxml, embedded labels, table is [Section Access]);

left join(Group)//Exceldeki Section Access sayfasındaki grubu left join ile aşağıdaki Group sayfasına bağlıyoruz.

LOAD [GROUP],

[MUHASEBE],

[GELIR YONETIMI],

[URETIM PLANLAMA],

[REZERVASYON],

[REKLAM],

[YURT DISI PAZARLAMA],

[TURKIYE PAZARLAMA],

[AMERIKA],

[ASYA & UZAKDOGU],

[DOGU AVRUPA VE RUSYA],

[ORTA & GUNEY AVRUPA],

[ORTADOGU & AFRIKA],

[HANDLING SOZLESMELER],

[OPERASYON KONTROL],

[LOJISTIK, IC HAT & POSTA],

[ISTANBUL],

[IZMIR],

[ANKARA],

[ADANA],

[ANTALYA],

[NOBETCI MD. - A EKIBI],

[NOBETCI MD. - B EKIBI],

[NOBETCI MD. - C EKIBI],

[NOBETCI MD. - D EKIBI]

FROM

CARGO_Yetkilendirme.xlsx

(ooxml, embedded labels, table is Groups);

Section Access;//Bu komut ile yetkilendirme kodunun başlatıyoruz.

LOAD [ACCESS],

NTNAME,

[GROUP]

FROM

CARGO_Yetkilendirme.xlsx

(ooxml, embedded labels, table is [Section Access]); //Exceldeki Section Access listesini yüklüyoruz.

Section Application; //Bu komut ile yetkilendirme kodunun tüm dökümanda kullanılmasını sağlıyoruz.

Helps?

Tags (2)
11 Replies
Not applicable

Re: section access

helle

Try use uppercase for your group

QSense
Contributor II

Re: section access

hi

It didnt work

Partner
Partner

Re: section access

Hi,

both your section acces table and your data with which you associate your section access should be in uppercase.

So, for both try upper(Group) as Group.

Not applicable

Re: section access

ACCESS  NTNAME GROUP

USER

NTD_EBI\S_SAGLAMALL

GROUPMUHASEBEGELIR YONETIMIURETIM PLANLAMA  REZERVASYON 
ALLYYYY

and go document properties\Opening\

select Initial data reduction  based on section acces

QSense
Contributor II

Re: section access

ACCESSNTNAMEGROUP
ADMINISTEBIQV3\QV_USERALL
ADMINNTD_EBI\O_ATESALL
USERNTD_EBI\R_CANALL
USERNTD_EBI\I_EMULALL
USERNTD_EBI\C_DEGIRMENCIALL
GROUPMUHASEBEGELIR YONETIMIURETIM PLANLAMA 
ALL111
GROUP1100
GROUP2111

as you see both of them are uppercase

QSense
Contributor II

Re: section access

hi syukyoZHU

Unfortunately it didint work

Not applicable

Re: section access

i have un example, you can modifly this for you application

SECTION Access;

LOAD * INLINE [

ACCESS, USERID,PASSWORD, TYPETABLEAU,

ADMIN,  ADMIN,ADMIN, *

USER, DIRECTION, DIRECTION, DIRECTION

USER, ANALYSE, ANALYSE, ANALYSE

USER, RAPPORT, RAPPORT, RAPPORT

];

SECTION Application;

star is *;

TypeTablaux:

LOAD * INLINE [

    TYPETABLEAU, VALEUR

   

    DIRECTION, D

    ANALYSE, A

    RAPPORT, R

    TOUS, T

];

and

it should work

QSense
Contributor II

Re: section access

I have attached my files.

Does anybody have an idea?

Not applicable

Re: section access

I can't open your document Qlikview