topic Re: (De)activate hidden worksheet in QlikView

(De)activate hidden worksheet

Anonymous — Wed, 04 Sep 2013 15:27:52 GMT

Hi all,

I would like to hide a worksheet and open it with a action button (activate worksheet).

My problem is that if i hide the worksheet with relation = 0, it can't be activated.

Is there a possibility to show and to hide a worksheed by a action button?

If you need further infornation just tell me!

Thank you for helping,

Robert

julian_ortiz — Wed, 04 Sep 2013 15:43:07 GMT

Hi Robert.

I atached a qvw. Hope this helps.

I Created one variable to hide/show a worksheet with action.

Regards

Julian

antose — Wed, 04 Sep 2013 22:17:42 GMT

Tips! If you hide anything by mistake or with a wrong If-statement you can always show it again with Ctrl+Shift+S

Anonymous — Thu, 05 Sep 2013 09:07:39 GMT

Really great!

Thank you very much.

antose — Thu, 05 Sep 2013 09:51:24 GMT

Hi again!

I know you already have received a correct solution but have one more tips.

I'm not a big fan of big buttons so what you can do is to add a listbox and then have show condition on the sheet.

Anonymous — Thu, 05 Sep 2013 13:07:08 GMT

Thank you for this tip!

I don't need it for this problem, but it will help later!