Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
chrisgoudy
New Contributor II

buttons that change sheets don't work when 'show all sheets' unticked under security

My buttons work when 'show all sheets' under security is ticked, but not when it is ticked.

any ideas?

I have conditional vDisplay=() on each sheets general property page

I have given each button the following actions

Activate Sheet

     SheetID = SH()

Set Variable   

     Variable =vDisplay

     Value = ()

and I checked to make sure all the values match up

5 Replies
Not applicable

buttons that change sheets don't work when 'show all sheets' unticked under security

It may sound odd but have you checked your Macro module has Current Local Security set to Allow System Access, I have experienced issues with this in the past

chrisgoudy
New Contributor II

buttons that change sheets don't work when 'show all sheets' unticked under security

I'm not familiar with macro module.

Where can I find it?

Not applicable

buttons that change sheets don't work when 'show all sheets' unticked under security

it is under the tools menu - edit module

chrisgoudy
New Contributor II

buttons that change sheets don't work when 'show all sheets' unticked under security

tried it out, but didn't work.

Thanks though.

any other ideas?

Not applicable

buttons that change sheets don't work when 'show all sheets' unticked under security

I think I understand what you are trying to do and thinking back to my certification I found issues with the script running when you swapped from one sheet to another and ended up just showing and hiding the tabs and letting the user select the tab