Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
QSense
Creator II
Creator 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?

1 Solution

Accepted Solutions
Not applicable

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/

View solution in original post

7 Replies
giakoum
Partner - Master II
Partner - Master II

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

Hi,

I want to make section access base on tabs

giakoum
Partner - Master II
Partner - Master II

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

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
Master
Master

Hi All

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

Paul

narender123
Specialist
Specialist

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

Hi,

Please activate the following option:

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

Regards,