topic Re: button on/off by clik in QlikView

button on/off by clik

Thu, 11 Oct 2012 13:32:50 GMT

Hello everyone,

I have a button to select in a particular field when i clik on it.But what i need is to turn off the button when i clik on the same button.Is there any solution for that???.I have checked the comunity with the set variable condition o and 1 but that is not my requiremnt .

Re: button on/off by clik

Gysbert_Wassenaar — Thu, 11 Oct 2012 13:42:17 GMT

Add a macro as an action of the button:

Sub DisableButton

set obj = ActiveDocument.GetSheetObject( "BU01" )

set prop = obj.GetProperties

prop.EnableCondition.v = "1<0"

obj.SetProperties prop

end sub

Re: button on/off by clik

Thu, 11 Oct 2012 13:45:26 GMT

I don't understand why you should do it with a macro and not via an action / variable.

Why not have 1 button with 2 actions

- select in field (field you wish)

- change variable

- that variable is used to have that button conditionally disabled?

Re: button on/off by clik

MayilVahanan — Thu, 11 Oct 2012 13:49:05 GMT

I think attached file what you needed??

Please click the product select button..and test it.

Re: button on/off by clik

Thu, 11 Oct 2012 14:16:54 GMT

wünderbar.Thanks Mayil Vahanan Ramasamy thtis is exactly what i need.

Re: button on/off by clik

Wed, 11 Feb 2015 09:08:11 GMT

Hi,

Can you please tell me the procedure.

As I'm using qlikview personal edition.

Thanks in Advance.

Regards.

Pavan.

Re: button on/off by clik

Fri, 04 Dec 2015 11:10:50 GMT

Hey Pavan,

I had two expressions in a chart-

Expression 1
- SUM(WorkLogs) as an integer
Condition 1
- vViewExp1=0
Expression 2
- SUM(WorkLogs) as a percentage
Condition 2
- vViewExp1=1

I then used a button to switch between the two.

New Button > Actions > Add Actions > External > Set Variable

Variable
- vViewExp1
Value
- if(vViewExp1 = 1, 0,1)

Clicking the button controls switching from figures as integer to figures as percentage. As multiple charts on the same tab use this variable, when I click the button all related charts change.

Hope this helps!

Dan