topic Re: Only allow certain users to view a particular tab in QlikView

Only allow certain users to view a particular tab

stevelord — Wed, 05 Mar 2014 01:45:25 GMT

Hi, I have this nice big dashboard with a dozen tabs I'd like to share out with the company via document cals assigned to other user groups. One tab has individual biometric information I do NOT want to share out with the company. Is there a simple way, say in tab properties, for me to check a checkbox and put in a list of the user groups allowed to view that biometrics tab?

So for the document, I'd have reporting, marketing, tech, and customerservice groups given a document cal to view the document

and for the biometrics tab of the document, I'd want only the tech team to be able to view it, while all those other teams can still view all the other tabs.

I know I could kick the biometrics to their own dashboard, but thought I'd check for a way to do this without piling up (any more) dashboards.

Re: Only allow certain users to view a particular tab

chiru_thota — Wed, 05 Mar 2014 01:54:49 GMT

You may try as below approach.

Re: Only allow certain users to view a particular tab

SunilChauhan — Wed, 05 Mar 2014 03:03:30 GMT

i am agree with chiranjeevi but my suggestion is to use below in Conditional

Lower(osuser())='Domain\loginame1' or lower(osuser())='Domain\loginname2'

hope this helps

Re: Only allow certain users to view a particular tab

maxgro — Wed, 05 Mar 2014 22:32:04 GMT

you can find an example (.qvw) here

Sheets Security with Section Access

Re: Only allow certain users to view a particular tab

stevelord — Thu, 06 Mar 2014 01:57:23 GMT

You all rock, all three approaches have their uses. I like the match ouser approach because you can drop a list of users in there and flank them with the match, and it confines itself to the one sheet while leaving the other sheets open. (The = approach works too, but if the list starts getting long you feel it when you have to maintain line by line around the osuser= part.)

The qvw script example made me an unexpected competent at handling section access when I was looking for a shortcut around section access. I did accidentally lock myself out of the sheet for all time when I tried something- because the script applies to all sheets and you can't get into the qvw at all if you're not on one of the lists. It may be great if I have to maintain more than one sheet in a document, but for now I'm just trying to whitelist the one sheet.

Thanks again, problem solved and one less dashboard needed since I can just lock down the sensitive sheet on this one.

Re: Only allow certain users to view a particular tab

vikasmahajan — Thu, 06 Mar 2014 10:49:56 GMT

Section Access is best Approach ....

Vikas