Discussion Board for collaboration on QlikView Scripting.
on my multi tab dashboard I have tab level condition for select filter like below.
set q = ActiveDocument
set s = q.Sheets("Co-Promotion Deal information")
if s.IsActive then
it works fine.
but now i need to hide sheets based on qlikview user like below.
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?
why you are using macro ?
i am using sheet level macro to lock, unlock and select few filters.