topic Change Color of Buttons on Click by using macro in QlikView

Change Color of Buttons on Click by using macro

Sat, 18 Sep 2010 16:16:35 GMT

Hello everyone

I need to change color of my buttons after they are clicked. I have already a macro triggered by the buttons which hides and shows charts. So I want to add some codes to those macros in order to change colors of buttons.

I have found some related topcis in forum but I could not open any of them. So I would be preciated if someone can send me VB codes.

Thank You

HealMe_Solutions

Change Color of Buttons on Click by using macro

Anonymous — Sat, 18 Sep 2010 17:16:09 GMT

There are many way to do this. Here is an example:
1. Create a variable for color, for example vColor, and use it in your button color (calculated color):
=$(vColor)
2. Macro that switches color:


sub Macro
 set c = ActiveDocument.Variables("vColor")
 if c.GetContent.string="rgb(255,200,200)" then
 c.SetContent "rgb(200,255,200)", true
 else
 c.SetContent "rgb(255,200,200)", true
 end if
end sub

Apparently you can include this code in your existing macros

Change Color of Buttons on Click by using macro

Sat, 18 Sep 2010 18:06:33 GMT

Thank you for your reply Michael.

A last Question. Where Should I create vColor variable, in Load script, in macro VB part or some where in the Button?

Thank You

Change Color of Buttons on Click by using macro

Anonymous — Sat, 18 Sep 2010 19:27:52 GMT

Not in macro Variables can be created in the script on from front end. In this case, the appropriate way is to use toolbar Setting -> Variable Overview, click Add, type variable name (in this case vColor), and OK.

Change Color of Buttons on Click by using macro

Sun, 19 Sep 2010 16:12:51 GMT

Nice sharing.

Thanks to all.

ERP Consulting
SAP ERP Consultants

Change Color of Buttons on Click by using macro

Mon, 20 Sep 2010 07:59:38 GMT

Thank you all. It helped so much...

Change Color of Buttons on Click by using macro

Tue, 25 Oct 2011 13:26:01 GMT

Hi All, I have a similar question and I having some trouble inputting this in my macro. Anyway someone can explain this simplier?