Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

stevelord
Not applicable

Only allow certain users to view a particular tab

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.

1 Solution

Accepted Solutions
chiru_thota
Not applicable

Re: Only allow certain users to view a particular tab

You may try as below approach.

Tab security.jpg

5 Replies
chiru_thota
Not applicable

Re: Only allow certain users to view a particular tab

You may try as below approach.

Tab security.jpg

SunilChauhan
Not applicable

Re: Only allow certain users to view a particular tab

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

maxgro
Not applicable

Re: Only allow certain users to view a particular tab

you can find an example (.qvw) here

Sheets Security with Section Access

stevelord
Not applicable

Re: Only allow certain users to view a particular tab

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.

vikasmahajan
Not applicable

Re: Only allow certain users to view a particular tab

Section Access is best Approach ....

Vikas