Discussion Board for collaboration related to QlikView App Development.
Hi, I have a requirement, which I feel would be common in most implementations. Based on the user login, I need to allow/disallow tabs.
This will be a sample maintenance, say SH01 is the sheet id. Based on the user login for e.g. Peter, he should get access to both sheets. MacGill should get access only to SH01.
Can you please help how to implement this.
See, you can always use variable instead of using the OsUser() directly, but in that case too, you have to compare that value with some string, right?
hmm. This link shows how to implement using section access. I can't afford to take the user name as input. The osuser is captured in a variable and based on that variable and the configuration i showed above it should decide to allow/disallow tabs.
it is not a comparison against a string. it is a comparison against a static table that i have got.
You mean, you have table like:
If so, you can give a try (not sure):
=If(osuser()=User, Sheet)='SH01' // for sheet1