Trying to hid sheet objects with button pushes

[#1]

I am trying to use buttons to turn tableboxes, charts and statistic boxes on and off of a tab.  Essentially, I am trying to develop a compliace tab for our Dispatch data that will allow me to visualize via several objects pass/fail status of thousands of calls.  I am hoping that I can add a button that says "Show Turn Out" and have the four screen objects that detail turn out display.  If I hit the "Show Drive Time" button, the Turnout objects would turn off and the Drive Time objects would turn on.

This would be incredibly easy in a language like Visual Basic, but as a new QlikView user, I am frankly stumped and frustrate.

Any help is appreciated.

Bob

HELP!!!!

[m_woolf · Accepted solution]

See the attached qvw

[MayilVahanan]

Hi

In button,

Properties -> Action-> Add -> External -> Set Variable

Variable - > vshow

Value -> If(vShow = 0, 1,0)

Then Click Ok.

In Chart -. Properties -. Layout ->Show->Conditional

= vshow

vshow is a variable.

Hope it helps

[#4]

create variable

vHide =0

then on button -->Action --->select external--> select set varable --> then write -->variablename = vHide and value=0

now on object -->properties-->layout -->conditional-->write  vHide

[#5]

All -

Each of your resolutions worked.  The qvd that was provided first worked great.  Unfortunatly, I am still running into the same issues.  There is something different between my implementation and the ones provided.  I opened them side by side and cannot identify any differences.  I am seeing different tabs, but am chalking that up to different versions of the software. 

I will relook at this on Tuesday.  For all in the USA, happy and safe Memorial Day Weekend!  For the rest of the world, have a great weekend!

Bob

All -

Your answers were all correct, but QlikView places a sniky little switch on the Document Properties that must be turned off for the logic to work  On the Document Properties --> Security Tab you MUST UNCHECK the Show All Sheets and Objects button for the Conditional Logic that you all demonstrated to work.

Thanks for all the help.

[#6]

All -

Each of your resolutions worked.  The qvd that was provided first worked great.  Unfortunatly, I am still running into the same issues.  There is something different between my implementation and the ones provided.  I opened them side by side and cannot identify any differences.  I am seeing different tabs, but am chalking that up to different versions of the software. 

I will relook at this on Tuesday.  For all in the USA, happy and safe Memorial Day Weekend!  For the rest of the world, have a great weekend!

Bob