topic Re: change color of text on button after click event in QlikView

change color of text on button after click event

Thu, 01 Aug 2013 11:45:26 GMT

hi guys,

Is there any solution for changing color of text on button.
After i click on button i want the color of text should get changed so that it can be easily identified which button is clicked...

thanks..

Re: change color of text on button after click event

Thu, 01 Aug 2013 11:51:48 GMT

Under Font Propery there is a button Color where you can make color of your text be calculated. Example:

if(vSomeVar = 0, Red(), White())

You can set button color to be calculated too. See Color button in General Tab.

Re: change color of text on button after click event

Thu, 01 Aug 2013 12:08:40 GMT

Hi,
I am using following logic but no result..

if($(vSomeVar) = 0, Red(), White())

Re: change color of text on button after click event

Thu, 01 Aug 2013 12:09:34 GMT

Hi mohit,
I am using personal edition so plz give me details here only...

Re: change color of text on button after click event

er_mohit — Thu, 01 Aug 2013 12:11:51 GMT

Change Color On Button Click

/*************************************************************************/

Firstly Create A Variable Vchange =0

then create a button

Right Click On button-->Action-->Add Action--->External---->Set Variable

then On Above side Name Of Variable-->Vchange-->

in Value write--> =If(Vchange=0,1,0)

then on Font Tab Click On Colour -->Tick on Calculated -->add Expression

if(Vchange=0,rgb(255,0,0))

hope it helps you

Re: change color of text on button after click event

Thu, 01 Aug 2013 13:01:10 GMT

Hi mohit,

It is not working..

I am using...

in actions -> set variable -> variable : vSomeVar

value : =if($(vSomeVar)=0,1,0)

in font -> calculated -> if($(vSomeVar) =0,rgb(255,0,0))

i want color of text should change to red when button is active

white when button is inactive

Re: change color of text on button after click event

MayilVahanan — Thu, 01 Aug 2013 13:04:58 GMT

Try like this

in actions -> set variable

varibale : vSomeVar

value: =if(vSomeVar = 0, 1, 0)

in font -> calculated

= if(vSomeVar = 0, white(), red())

Hope that helps

Re: change color of text on button after click event

er_mohit — Thu, 01 Aug 2013 13:07:49 GMT

why you use dollar sign simply write the variable name

see the attached image

Re: change color of text on button after click event

Thu, 01 Aug 2013 13:27:05 GMT

Hi guys,

I am getting following error...

PFA

Re: change color of text on button after click event

Thu, 01 Aug 2013 13:39:42 GMT

You need to CREATE the variable first. SomeVar is simply used to denote that you should create 'Some Variable' for use in this situation. Go to Variable overview (Ctrl+alt+v) and create a variable there with the name of your choice.

Use this name that you selected in place of 'SomeVar'.

Hope this helps.

Cheers,

Re: change color of text on button after click event

MayilVahanan — Thu, 01 Aug 2013 13:57:50 GMT

Go to Variable overview (Ctrl+Alt+v) and create a variable there with the name "vSomeVar"

Hope it helps

Re: change color of text on button after click event

Thu, 01 Aug 2013 14:00:45 GMT

Hi,

Go to Variable overview (Ctrl+Alt+v) and create a variable there with the name "vSomeVar".

Hope it helps.

Cheers,

Re: change color of text on button after click event

Fri, 02 Aug 2013 05:30:47 GMT

Hi guys,

Now i have again new issue.
I completed the first task now new issue is...

I have 4 buttons ( closed won, closed lost, lead dead and open opportunities)

I want the functionality as below:

1) whenever i click on closed won then color of text should get changed to red and rest buttons should be in white text...

2) same functionality to other buttons also...

Right now whenevr i click on any button it changes color to red and again selecting other button it also changes to red but previous button color remains same.....

PFA

Re: change color of text on button after click event

Fri, 02 Aug 2013 07:05:47 GMT

Hi again, this is very easily done. To make it easier to remember which values correspond to what, do the following:

For Closed Won:

In actions -> set variable

varibale : vSomeVar

value: =if(vSomeVar = 'Won', '', 'Won')

in font -> calculated

= if(vSomeVar = 'Won', red(), white())

For Closed Lost:

In actions -> set variable

varibale : vSomeVar

value: =if(vSomeVar = 'Lost', '', 'Lost')

in font -> calculated

= if(vSomeVar = 'Lost', red(), white())

For Lead Dead:

In actions -> set variable

varibale : vSomeVar

value: =if(vSomeVar = 'Dead', '', 'Dead')

in font -> calculated

= if(vSomeVar = 'Dead', red(), white())

For Open Opportunities:

In actions -> set variable

varibale : vSomeVar

value: =if(vSomeVar = 'Open', '', 'Open')

in font -> calculated

= if(vSomeVar = 'Open', red(), white())

All this does is interchange the value of vSomeVar with a word contained in the button text (so you can easily remember which is which). The font colour then checks if the value in vSomeVar corresponds with it's button text and switches to red if it does.

Hope this helps!

Cheers,

Re: change color of text on button after click event

Fri, 02 Aug 2013 09:47:56 GMT

thanks clevergoat...

it worked