topic Need help un-hiding sheets when a field is set in QlikView

Need help un-hiding sheets when a field is set

Fri, 16 Nov 2012 15:39:28 GMT

Hi! I'm new to QV, so any help you can provide is greatly appreciated. I currently have a document with 5 sheets. The first sheet forces the user to select one or more of three fields. I want to hide the remaining 4 sheets in the document until at least one of the fields has a value set in the first sheet.

I am trying to accomplish this by doing the following: hide the remaining 4 sheets by setting "Document Setting" -> "Sheet Properties" -> "Show sheet" -> "Conditional"=0. Then I am setting a trigger when a selection is made on the field: "<field-name" -> "On select" -> "Add" -> "Activate Sheet" -> "<sheet-id>".

But this isn't working. I am assuming this is becuase "activate sheet" is not the intended action, but it is the closest action I could find to what I wnated to do. Can somebody please help me?

thanks,

Haritha

Re: Need help un-hiding sheets when a field is set

shree909 — Fri, 16 Nov 2012 15:44:36 GMT

Hi u can create some buttons for the four sheets and drive those sheets with the buttons.

button 1 --- shows 1st sheet

button 2 shows the scond sheet

something like this

Re: Need help un-hiding sheets when a field is set

Fri, 16 Nov 2012 15:48:31 GMT

Thank you for the prompt response, shree909. But I want this to be seamless and transparent to the user, which is why I am leaning towards using triggers.

Re: Need help un-hiding sheets when a field is set

shree909 — Fri, 16 Nov 2012 15:54:26 GMT

did u try using the layout conditons..

like ur sheet should get openend when u select something from the listbox

uisng some getfield selections ...

Re: Need help un-hiding sheets when a field is set

Fri, 16 Nov 2012 15:59:38 GMT

Thanks very much, shree909 - that led me in the right direction. Thanks a ton for your help!

Re: Need help un-hiding sheets when a field is set

shree909 — Fri, 16 Nov 2012 16:01:33 GMT

did u try using the layout conditons..

like ur sheet should get openend when u select something from the listbox

uisng some getfield selections ...

Re: Need help un-hiding sheets when a field is set

Fri, 16 Nov 2012 16:22:40 GMT

Hi Muthyala,

To show only the specific sheets, You can create some buttons in the home page and give one variable and give values to different sheets. I have attached the document with home page sheet, and four other sheets . Hope it helps you .

Regards

Ramesh

Re: Need help un-hiding sheets when a field is set

jagan — Fri, 16 Nov 2012 16:37:12 GMT

Hi,

Hope attached file helps you.

Refer sheet properties Show Sheet -> Conditional section in Sheet1

Regards,

Jagan.