Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
QSense
Creator II
Creator 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?

11 Replies
Not applicable

helle

Try use uppercase for your group

QSense
Creator II
Creator II
Author

hi

It didnt work

jjfabian
Partner
Partner

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

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
Creator II
Creator II
Author

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
Creator II
Creator II
Author

hi syukyoZHU

Unfortunately it didint work

Not applicable

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
Creator II
Creator II
Author

I have attached my files.

Does anybody have an idea?

Not applicable

I can't open your document Qlikview