topic Re: Hide and Show prob? in QlikView

Hide and Show prob?

paulwalker — Mon, 24 Feb 2014 18:13:34 GMT

Hi Community,

PFA,

I have 2 variables, vShow and vShow1..

i have 2 charts when i am click 1st button it show one chart and when i am click 2nd button i want to open second chart and 1st chart hide

Re: Hide and Show prob?

aveeeeeee7en — Mon, 24 Feb 2014 18:17:34 GMT

Hi Paul

See the Attachment.

Re: Hide and Show prob?

aveeeeeee7en — Mon, 24 Feb 2014 18:19:09 GMT

I am not able to open your Qvw.

Re: Hide and Show prob?

maxgro — Tue, 25 Feb 2014 22:52:11 GMT

you can use one variable, vChart

button 1 set vChart = 1

button 2 set vChart = 2

in layout tab of the charts use show conditional with expression

in chart 1 vChart=1

in chart 2 vChart =2

optional: change color of the buttons using vChart

more: n buttons for n charts: in that way you can simulate a single object container with n charts

Re: Hide and Show prob?

jagan — Wed, 26 Feb 2014 02:36:22 GMT

Hi Paul,

Just use one variable vShow

and set the variable values when button1 then 1

and when button2 is clicked then 2.

Now in chart1 - Chart Properties -> Layout tab -> Conditonal - Give this condition = vShow=1

Now in chart2 - Chart Properties -> Layout tab -> Conditonal - Give this condition = vShow=2

Hope this helps you.

Regards,

Jagan.

Re: Hide and Show prob?

Wed, 26 Feb 2014 04:17:20 GMT

Define one variable like vShow=1

then layou of first chart----> vShow=1 and layout of second chart--->vShow=2

first button---->action--->external---->setvariable--->vShow=1

second button--->action---->external---->setvariable----->vShow=2

regards

Mahesh T

Re: Hide and Show prob?

er_mohit — Wed, 26 Feb 2014 04:36:52 GMT

Try this for one button

Right click the sheet and choose properties

In General tab -> Show sheet -> select the conditional and give 0 and click ok..

Sheet is hide..To view -> setting - document properties -> sheets-> select the sheet and click properties and tick to show..

Set variable vhide = 0. and use button to set the variable value as 0/1 by using if(vhide=0,1,0) and use vhide in conditional option in sheet properties..to show or hide the sheet..

and same for 2nd variable

Re: Hide and Show prob?

Wed, 26 Feb 2014 05:19:34 GMT

Hi Paul,

1.Create variable vShow=0 and vShow1=0

2. Create button1 in properties. --> Actions tab -- click add button-- select External -- select Set variable. then in variable place vShow that is variable name and in value place 1. then click Ok

3.Create button2 in properties. --> Actions tab -- click add button-- select External -- select Set variable. then in variable place vShow1 variable name and in value place 1.then click Ok

4. Create a first chart. properties--- layout tab-- under show click condition type vShow=1. click ok

5. Create a second chart. properties--- layout tab-- under show click condition type vShow1=1 click ok.

6. when u click first button, first chart will popup. when u click second button, second chart will popup and first chart will hide., because condition is vshow1=1.

Regards,

Kanthu