Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
Valued Contributor III

Re: Assing CAL to user to view particular tab

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

8 Replies
aveeeeeee7en
Valued Contributor III

Re: Assing CAL to user to view particular tab

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

Re: Assing CAL to user to view particular tab

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
Contributor

Re: Assing CAL to user to view particular tab

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

Re: Assing CAL to user to view particular tab

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

Re: Assing CAL to user to view particular tab

Thank you..

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

Thanks,

Shailesh

Re: Assing CAL to user to view particular tab

Yes you can,

Use osuser() function

Regards

ASHFAQ

aveeeeeee7en
Valued Contributor III

Re: Assing CAL to user to view particular tab

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

Re: Assing CAL to user to view particular tab

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

Community Browser