topic Re: Assing CAL to user to view particular tab in QlikView

Assing CAL to user to view particular tab

Mon, 26 Jan 2026 18:19:17 GMT

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

Re: Assing CAL to user to view particular tab

aveeeeeee7en — Wed, 24 Sep 2014 10:42:46 GMT

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

Regards

Av7eN

Re: Assing CAL to user to view particular tab

Colin-Albert — Wed, 24 Sep 2014 10:43:24 GMT

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.

Re: Assing CAL to user to view particular tab

svsudhakar — Wed, 24 Sep 2014 10:48:36 GMT

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

Re: Assing CAL to user to view particular tab

ashfaq_haseeb — Wed, 24 Sep 2014 10:49:40 GMT

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

Re: Assing CAL to user to view particular tab

Wed, 24 Sep 2014 11:31:57 GMT

Thank you..

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

Thanks,

Shailesh

Re: Assing CAL to user to view particular tab

ashfaq_haseeb — Wed, 24 Sep 2014 11:33:30 GMT

Yes you can,

Use osuser() function

Regards

ASHFAQ

Re: Assing CAL to user to view particular tab

aveeeeeee7en — Wed, 24 Sep 2014 11:35:53 GMT

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'

Re: Assing CAL to user to view particular tab

Wed, 24 Sep 2014 12:36:08 GMT

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