Action based display

[upaliwije]

Hi

In my QV document I have two sheet objects Pivot Table and a bar chart. When I open the document both objects appear simultaneously in the screen . I want to show one object (pivot Table ) first and then after clicking a button bar char should appear next to Pivot Table when I click tiger some action  while the pivot table should still be on display. Pls help to do this . My sample  is attached herewith please

[ajayrai]

Check this , create a variable and set action set variable on the click of button. Check the attached file.

[upaliwije]

Dear Rai

Thanks. but I can not view your reply

[rwunderlich]

You will a button that uses an Action to toggle a variable that controls whether the bar chart is shown.

The bar chart will use a conditional show that tests the variable. The attached sample demonstrates this. Let me know if you have an questions about the details.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[upaliwije]

Dear Rob

Thanks

I have copied the button to document and created the  vShowBarchart in variable overview. But it is not working. Can u pls advise what else I should do. Pls also elaborate me how an existing object can hide new object can display when trigging  a button

[ajayrai]

Check the application attached in my previous reply.

[rwunderlich]

Make sure you set the variable in the variable to an initial value of 0.

Can you upload a sample document that shows the trouble you are having?

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[upaliwije]

Now that problem I sorted out. My other issue  is whether I can use action button to show one object hide other object in same action. pls help

[ajayrai · Accepted solution]

You can refer my application that single button is for hide and show at same .

You have to set action like this : =if(vHide=0,1,0), and set conditional for one chart vHide=1 and for other chart set it to vHide=0.