Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

user level security and tab level selection issue

on my multi tab dashboard I have tab level condition for select filter like below.

Sub selectsheet

set q = ActiveDocument

set s = q.Sheets("Co-Promotion Deal information")

if s.IsActive  then

q.Fields("DEAL_GROUP").Select("COPRO")

q.Fields("DEAL_GROUP").lock

end if

it works fine.

but now i need to hide sheets based on qlikview user like below.

=OSUser()<> 'user'

but doing so is braking my vb code above becasue when other tabs are selected error on below.

>set s = q.Sheets("Co-Promotion Deal information")

how to make both work?

Thanks

Jay

3 Replies
Not applicable

Re: user level security and tab level selection issue

help.

Not applicable

Re: user level security and tab level selection issue

why you are using macro ?

Not applicable

Re: user level security and tab level selection issue

i am using sheet level macro to lock, unlock and select few filters.

Community Browser