Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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.
using QVuser() or OSuser() functions u can enable the conditional sheet visible
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
Thank you..
Can't I do this activity without using section access???
Thanks,
Shailesh
Yes you can,
Use osuser() function
Regards
ASHFAQ
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'
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