Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Assing CAL to user to view particular tab

Hi all,

Can I assign CAL to a user so that user can view only particular tab from the application.

I mean to say when the user logged in than user can view only that particular tab and not other tabs.

Can it be possible?

Regards,

Shailesh

1 Solution

Accepted Solutions
aveeeeeee7en
Specialist III
Specialist III

Yes, it is possible

1st Method:

Try something like this:

OSUSER<>'Username'      // Here Username is the name of the specific user on which you have given him the Access.

Or, QVUSER<>'Username'

2nd Method:

In your Section Access Sheet, don't give particular User Access of Sheet you want to hide and for other users give him the Access.

Eg.

User SheetId

John SH01

John SH02

John SH03

John SH01

John SH02

John SH03

John SH04

// Here I have not given John the Access for Sheet ID SH04

By using the below expression he will not able to see the particular Sheet.

Use the below expression in Conditional:

sum(if(SHEETID='SH57',1,0))>=1

Conditional ID.png

Regards

Av7eN

View solution in original post

8 Replies
aveeeeeee7en
Specialist III
Specialist III

Yes, it is possible

1st Method:

Try something like this:

OSUSER<>'Username'      // Here Username is the name of the specific user on which you have given him the Access.

Or, QVUSER<>'Username'

2nd Method:

In your Section Access Sheet, don't give particular User Access of Sheet you want to hide and for other users give him the Access.

Eg.

User SheetId

John SH01

John SH02

John SH03

John SH01

John SH02

John SH03

John SH04

// Here I have not given John the Access for Sheet ID SH04

By using the below expression he will not able to see the particular Sheet.

Use the below expression in Conditional:

sum(if(SHEETID='SH57',1,0))>=1

Conditional ID.png

Regards

Av7eN

Colin-Albert

You assign a CAL to give a user access to the whole document.

Within each the document, you can use either qvuser() or osuser() to show or hide the sheet.

svsudhakar
Creator
Creator

using QVuser() or OSuser() functions u can enable the conditional sheet visible

ashfaq_haseeb
Champion III
Champion III

You need to look at osuer()

or have a look at this post for section access implementation.

http://community.qlik.com/docs/DOC-4435

Regards

ASHFAQ

Not applicable
Author

Thank you..

Can't I do this activity without using section access???

Thanks,

Shailesh

ashfaq_haseeb
Champion III
Champion III

Yes you can,

Use osuser() function

Regards

ASHFAQ

aveeeeeee7en
Specialist III
Specialist III

Yes, you can do this without Section Access.

Try something like this:

OSUSER<>'Username'      // Here Username is the name of the specific user on which you have given him the Access.

Or, QVUSER<>'Username'

Not applicable
Author

Thanks a ton.

But my requirement is bit change. I want to assign a tab to a Document CAL assigned user not the OS User.

Irrespective of OS User the tab need to show to only those users which are having Document CAL.

Hope I am clear with requirement.

Thanks,

Shailesh