topic Re: Tab Access in QlikView

Tab Access

Mon, 25 Mar 2013 15:06:19 GMT

I want to make a specific tab viewable by certain users only.

In my load script, I have the following:

Section Access;

Load * inline [

USERID, PASSWORD, ACCESS, GROUPNAME

bloggsj jb,USER,G1

smithj,js,USER,G2

admin,1,ADMIN,*

];

Section Application;

Star is *;

Groups:

load * inline [

GROUPNAME

];

Then in the tab property, I have the following condition

=FieldIndex('GROUPNAME', 'G1')

I would therefore only expect bloggsj and Admin to be able to view the tab but all 3 can.

What am I doing wrong?

Re: Tab Access

Mon, 25 Mar 2013 15:24:05 GMT

Hi, have you ticked the option in document properties >opening...

'Initial data reduction based on section access'

If this isnt ticked then no data will be restricted.

Re: Tab Access

Anonymous — Mon, 25 Mar 2013 15:32:39 GMT

I'm not sure it's a relaible approach to use fieldindex(). Try this:
match(concat({1} distinct GROUPNAME),'G1')

Regards,
Michael

Re: Tab Access

Anonymous — Thu, 04 Apr 2013 14:01:26 GMT

With reference to Michael's comment "I'm not sure it's a relaible approach to use fieldindex(). Try this:

match(concat({1} distinct GROUPNAME),'G1') "

You are VERY right. fieldindex does not work (for me). I get different results on the Web than I do on my server copy when using fieldindex. How that can be I will never know!

I am happy to say that "match(concat({1} distinct GROUPNAME),'G1')" works perfectly!

Thanks for that, I was really stuck.

Regards

David

Re: Tab Access

alexpanjhc — Thu, 04 Apr 2013 14:37:16 GMT

if they all have a windows login, I'd list them in the propety ->general->condition.

=upper(osuser())='domain\user'

will that help?