topic Re: Section Access in QlikView

Section Access

Fri, 11 Nov 2011 09:24:54 GMT

Hi all,

In my Current application contains, 4 script tabs i.e; User1, User2, User3, User4.

And i provided the section access for the application.

Now what i am trying is , Based on user login that user "Edit Script" should be visible and the rest should be disable.

EX1: IF User Login by USer1, then only User1 and Main Script tab should visible.

EX2: IF User Login by USer2, then only User2 and Main Script tab should visible.

Section Access:

UserID, Password

User1, User1

User2, User2

User3, User3

User4, User4

Is this possible ?

Pls see the attached qvw file.

Regards

Venkat

Section Access

Fri, 11 Nov 2011 10:22:37 GMT

Hi,

This is not possible because there is now way to hide a tab with a expression.

Halmar

Re: Section Access

Mon, 31 Dec 2012 08:11:03 GMT

Hi, Halmar is correct in my opinion. Hiding tabs through an expression is not a solution. Please see enclosed (document to hopefully provide a solution to your question (credits to J. Fourman). Feel free to let me know if you have any further questions. Hoping to have been of help and best wishes. Barbara Brouwer

Re: Section Access

SunilChauhan — Mon, 31 Dec 2012 08:34:17 GMT

Section Access:

Load * inline [

UserID, Password,SHEETID

User1, User1,SH01

User2, User2,SH02

User3, User3,SH03

User4, User4,SH04

];

section Application;

Reload the application

in document propertied select checkbox-> Intial data resuction based on section access

go to all sheet properties and in genral tab-> conditional

and write

=Sum(if(SHEETID='SH01',1,0))>=1 for sheet 1

=Sum(if(SHEETID='SH02',1,0))>=1 for sheet 2

=Sum(if(SHEETID='SH03',1,0))>=1 for sheet 3

=Sum(if(SHEETID='SH04',1,0))>=1 for sheet 4

hope this helps

Re: Section Access

khadeer — Mon, 31 Dec 2012 09:36:51 GMT

Hi Venkat,

I hope its not possible to hide "Edit Script" by using section access. U can use hidden script and u can give password to that, so who known the password will see that script.

We can do section access in data level, sheet leve, and document level in front end.

Hope it will help you.

Regards,

Khadeer