topic Re: section access based on tab in QlikView

section access based on tab

QSense — Tue, 26 Jun 2012 06:06:57 GMT

Hi ,

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

In excel file ,in groups section,

Group	MUHASEBE	GELIR YONETIMI	URETIM PLANLAMA	REZERVASYON
All	1	1	1	1
Group1	1	0	0	0
Group2	1	1	1	0

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

and group name

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

USER	NTD_EBI\S_SAGLAM	All
USER	NTD_EBI\M_HAPCIOGLU	Group1
USER	NTD_EBI\A_METIN2	All
USER	NTD_EBI\A_KONAR	Group1

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?

Re: section access based on tab

giakoum — Tue, 26 Jun 2012 06:46:59 GMT

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

Re: section access based on tab

QSense — Tue, 26 Jun 2012 07:10:18 GMT

Hi,

I want to make section access base on tabs

Re: section access based on tab

giakoum — Tue, 26 Jun 2012 07:23:16 GMT

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.

Re: section access based on tab

Tue, 26 Jun 2012 07:54:09 GMT

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/

Re: section access based on tab

paulyeo11 — Thu, 25 Jul 2013 10:52:26 GMT

Hi All

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

Paul

Re: section access based on tab

narender123 — Fri, 26 Jul 2013 10:32:26 GMT

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

Re: section access based on tab

Mon, 29 Jul 2013 00:25:26 GMT

Hi,

Please activate the following option:

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

Regards,