Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Buttons

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

10 Replies
rubenmarin

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

alexandros17
Partner - Champion III
Partner - Champion III

My Example

Not applicable
Author

Hi Ruben

thanks for ur reply

but i cant get it.

pls give me complete navigation

Thanks

Not applicable
Author

hi

i have personel edition

pls give me navigation

jpenuliar
Partner - Specialist III
Partner - Specialist III

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

rubenmarin

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

alexandros17
Partner - Champion III
Partner - Champion III

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

Not applicable
Author

Hi to all,

thanks to all for ur replies

alexandros17
Partner - Champion III
Partner - Champion III

Could you please Mark our answers?

Thanks