Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
QSense
Contributor II

section access based on tab

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 (1)
1 Solution

Accepted Solutions
Not applicable

Re: section access based on tab

Merhaba,

I have attached an example based on what is suggested in "Data protection and security in QlikView" document, i.e. I defined a condition for each sheet in sheet properties.

Pls. try to open it by the following userid/pwd combinations and see if it works, when you open it with "Administrator", you may see the script.

UserId, Password

--------------------------------------------------

ADMINISTRATOR, ADMINISTRATOR

U1, U1

U2, U2

Pls let me know any questions

Best regards

http://quickdevtips.blogspot.com/

7 Replies
giakoum
Honored Contributor II

Re: section access based on tab

My dear enemy your script should look like this :

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, Group

ADMIN, ADMIN, ADMIN,

USER, NTD_EBI\S_SAGLAM, U1, Group1

USER, NTD_EBI\M_HAPCIOGLU, U2, *

USER, NTD_EBI\A_METIN2, U3, Group1

USER, NTD_EBI\A_KONAR, U4, *

];

Note that * does mean that user NTD_EBI\A_KONAR will see all groups mentioned in section access so if you want him to see Group2 as well, you need to add this line also :

USER, NTD_EBI\A_KONAR, U4, Group2

Note also that this works with fields not tabs.

leave password field out if not needed.

giakoum

QSense
Contributor II

Re: section access based on tab

Hi,

I want to make section access base on tabs

giakoum
Honored Contributor II

Re: section access based on tab

Then use a new field name ShowCondition for example with values MUHASEBE,GELIR YONETIMI or anything else you need, apply section access to that and use it as a show condition for the sheet. See show condition in sheet properties.

I am not sure if there is a better way.

BR, giakoum.

Not applicable

Re: section access based on tab

Merhaba,

I have attached an example based on what is suggested in "Data protection and security in QlikView" document, i.e. I defined a condition for each sheet in sheet properties.

Pls. try to open it by the following userid/pwd combinations and see if it works, when you open it with "Administrator", you may see the script.

UserId, Password

--------------------------------------------------

ADMINISTRATOR, ADMINISTRATOR

U1, U1

U2, U2

Pls let me know any questions

Best regards

http://quickdevtips.blogspot.com/

paulyeo11
Valued Contributor II

Re: section access based on tab

Hi All

Sorry i need to move this post to the top , as i am to work on this .

Paul

narender123
Valued Contributor

Re: section access based on tab

Hi Aydin,

I had used your qvw its working but when i create the same qvw in my sytem then its not working preperly.When i entered the Id and password for U1 or U2 then it showed the all 4 tab.Why??nor working tab as per my condition??

Please see my qvw.

User id and password is same as your qvw.

Thanks

Not applicable

Re: section access based on tab

Hi,

Please activate the following option:

Settings --> Document properties --> openning --> Initial Data reduction based on section access

Regards,

Community Browser