topic user level security and tab level selection issue in QlikView

user level security and tab level selection issue

Tue, 03 Dec 2013 16:32:18 GMT

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

Thu, 05 Dec 2013 14:38:37 GMT

help.

Thu, 05 Dec 2013 21:13:14 GMT

why you are using macro ?

Mon, 09 Dec 2013 19:17:43 GMT

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