topic Re: Buttons in Qlik Learning Discussions

Buttons

Thu, 05 Feb 2015 10:00:22 GMT

Hi to All,

I have Pivot table and have 2 columns like Product and Opening Quantity.

I have two buttons like Visible and Invisible buttons.

when i click on "Visible button" ,i want display the Opening Quantity Column. When i ll clik on "Invisible button",i want hide that "Opening Quantity Column"

pls help me

Re: Buttons

rubenmarin — Thu, 05 Feb 2015 10:06:42 GMT

Hi chandra, you can create a variable like vShowOpQuantity, one button sets the value to "1" and the other to "0" (you can do this in only one button if you want)

Then you can check "Conditional" in the expression based on the value on the variable: =vShowOpQuantity

Re: Buttons

alexandros17 — Thu, 05 Feb 2015 10:08:29 GMT

My Example

Re: Buttons

Thu, 05 Feb 2015 10:12:42 GMT

Hi Ruben

thanks for ur reply

but i cant get it.

pls give me complete navigation

Thanks

Re: Buttons

Thu, 05 Feb 2015 10:14:09 GMT

i have personel edition

pls give me navigation

Re: Buttons

jpenuliar — Thu, 05 Feb 2015 10:22:58 GMT

Have a read on the link:

Enhancing the User Experience Using Conditional Expressions - Part II

This explains how to make use of Conditional Show to sheets/objects

Re: Buttons

rubenmarin — Thu, 05 Feb 2015 10:25:57 GMT

Menu config --> variable panel --> Add --> set vShowOpQuantity as name

In button "visible button" add action--> External-->Set variable. Name:vShowOpQuantity Value:1

In button "invisible button" add action--> External-->Set variable. Name:vShowOpQuantity Value:0

In Chart, tab Expressions, check Conditional and set =vShowOpQuantity

Re: Buttons

alexandros17 — Thu, 05 Feb 2015 11:02:29 GMT

You can do this even with only one button:

1) define a variable in the script: LET ShowHide = 1;
2) add a button where in the text write: =If(ShowHide = 1, 'Hide', 'Show')
3) Add in triggers -> external -> set variable in the upper textbox write: ShowHide, in the lower textbox write: =If(ShowHide = 1,0,1)
4) in your expression write in "Conditional" textbox: ShowHide=1 or ShowHide=0

Let me know

Re: Buttons

Thu, 05 Feb 2015 12:02:26 GMT

Hi to all,

thanks to all for ur replies

Re: Buttons

alexandros17 — Thu, 05 Feb 2015 12:42:15 GMT

Could you please Mark our answers?

Thanks

Re: Buttons

Fri, 06 Feb 2015 07:13:02 GMT

Hi Mark,

Your Explenation is Simply Superb.

Thanks you so much for your reply.

Regards

Chandra