topic Re: Action based display in QlikView

Action based display

upaliwije — Sat, 13 Feb 2016 04:53:14 GMT

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

Re: Action based display

ajayrai — Sat, 13 Feb 2016 05:08:41 GMT

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

Re: Action based display

upaliwije — Sat, 13 Feb 2016 05:20:30 GMT

Dear Rai

Thanks. but I can not view your reply

Re: Action based display

rwunderlich — Sat, 13 Feb 2016 05:37:11 GMT

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

Re: Action based display

upaliwije — Sat, 13 Feb 2016 05:50:34 GMT

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

Re: Action based display

ajayrai — Sat, 13 Feb 2016 06:22:39 GMT

Check the application attached in my previous reply.

Re: Action based display

rwunderlich — Sat, 13 Feb 2016 07:04:25 GMT

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

Re: Action based display

upaliwije — Sat, 13 Feb 2016 08:09:14 GMT

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

Re: Action based display

ajayrai — Sat, 13 Feb 2016 08:15:06 GMT

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.