topic Re: Trying to hid sheet objects with button pushes in QlikView

Trying to hid sheet objects with button pushes

Fri, 24 May 2013 18:25:57 GMT

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!!!!

Re: Trying to hid sheet objects with button pushes

m_woolf — Fri, 24 May 2013 18:35:56 GMT

See the attached qvw

Re: Trying to hid sheet objects with button pushes

MayilVahanan — Fri, 24 May 2013 18:37:48 GMT

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

Re: Trying to hid sheet objects with button pushes

Fri, 24 May 2013 18:41:08 GMT

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

Re: Trying to hid sheet objects with button pushes

Fri, 24 May 2013 19:48:50 GMT

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.

Re: Trying to hid sheet objects with button pushes

Fri, 24 May 2013 19:49:22 GMT

All -

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