topic Re: Hide/show an Object with button set variable in QlikView

Hide/show an Object with button set variable

Mon, 25 Jun 2012 14:45:04 GMT

Hi,

Can you help me?

I woul like to display and hide a chart based on a click of a button. Using the set variable option is only allowing me to display the object, but I wonder if I can hide the object with the same button, can someone advise?

Kind regards,

Jorge

Re: Hide/show an Object with button set variable

MayilVahanan — Mon, 25 Jun 2012 14:58:12 GMT

Hi,

Try this,

Button - action - Set Variable ->vhide

Value:

=If(vhide = 0, 1, 0)

In chart, use vhide variable in Layut-conditional - show = vhide

Hope it hepls

Re: Hide/show an Object with button set variable

Miguel_Angel_Baeyens — Tue, 26 Jun 2012 12:20:29 GMT

Hi Jorge,

I happened to have a very recent example on this. This is certainly possible and not very difficult, and it's very similar to what Mayil suggests.

Hope that helps.

Miguel

Re: Hide/show an Object with button set variable

Tue, 26 Jun 2012 12:36:26 GMT

Thanks a lot Mayil and Miguel for your help, this is exactly what I needed.

Best regards,

Jorge

Re: Hide/show an Object with button set variable

Mon, 16 Jul 2012 12:10:13 GMT

Hi Miguel,

The example works in the above document. But when I use the same in my current application it doesn't.

What could be the issue. Is some thing related to document properties.

Thanks

Laxmikant

Re: Hide/show an Object with button set variable

Tue, 29 Jan 2013 10:03:40 GMT

Hi i am using the same variable VshowHide. i was just wondering if the show Hide can actually Say something else in the button for instance Show Yearly or Show Summary as that is basically what the button does. switch between the reports.

=if(vShowHide='Show','Hide','Show') & ' Charts'

i did change the show ,, hide to yearly and summary the button still shows and hides the charts but the button doesn't update to yearly once the summary charts are hidden

thank you in advance

Kallie

Re: Hide/show an Object with button set variable

Fri, 07 Feb 2014 11:06:19 GMT

Hello Team

I need to press button for two times to for any action. why this is happening to. kindly any one help.

Thx

Srini

Re: Hide/show an Object with button set variable

Fri, 28 Feb 2014 11:56:03 GMT

I know that this was a long time ago...

Document Properties -> Tab Security -> Uncheck "Show All Sheets and Objects".

I was getting same problem... Nothing happened when button was pressed. It works fine now!

Maybe this will help someone later...

Regards,

BS.

Re: Hide/show an Object with button set variable

stevedark — Tue, 18 Mar 2014 14:19:34 GMT

Bruno, there is a useful short-cut key Alt+Shift+S that shows all objects regardless of their Show Condition. You can also get to this setting via the menu option you describe. If you have show all selected then variable show will not work.

Regarding showing and hiding objects I have uploaded a couple of example apps that may give some ideas as to what you can do with showing and hiding objects from a button click:

QlikView App: Show and Hide Windows Dynamically

QlikView App: At The Qlik Of A Button

Hope they are of interest.

Steve

Re: Hide/show an Object with button set variable

Anonymous — Wed, 10 Jan 2018 06:22:16 GMT

Hey Jorge, Could you tell me if I want to do the same with a value present in list. Example :

List has three values power, performance , response. By clicking power, another sKu list should open, so on. In the end all these values should direct to a button and by the click of the button a new object should open up. CAn it happen please help out.

Re: Hide/show an Object with button set variable

Anonymous — Mon, 18 Jun 2018 16:22:39 GMT

Sir KINDLY PLEASE HELP US,

HOW TO DISPLAY between Multiple Currencies using a variable. USING QLIK SENSE.....

EG : IF WE SELECT EURO BUTTON, IT SHOULD DISPLAY ONLY THE EURO COLUMN(WHICH IS MARKED IN THE BELOW MENTIONED PIC)...

Re: Hide/show an Object with button set variable

stevedark — Tue, 19 Jun 2018 10:05:10 GMT

This functionality is (finally) arriving in the June 2018 release of Qlik Sense.

Rather than showing or hiding the column though, it would probably be just as easy to have the one column with the calculation changing based on your selection of currency.

If you create a variable called vFXRate you could have something like this:

=Pick(Match(MinString([Base currency]), 'Euro', 'Poundsterling', 'US dollar'), 1, 0.93, 1.62)

You can then just multiple the expression in that column by the value coming back from the variable.

If you have the FX rates themselves loaded into a variable then you can pick that out from the table also, using a Min and set analysis so you get the FX for the right currency.

You would probably want two variables vFXRate and vFXName.

Hope that helps.

Steve

Re: Hide/show an Object with button set variable

hector_obregon_ — Thu, 08 Nov 2018 20:03:29 GMT

Thankssssssssssssssss.......