topic Re: Colour change to text box when clicked on in QlikView

Colour change to text box when clicked on

kfahri342 — Mon, 07 Aug 2017 15:36:23 GMT

Hi all,

I have a few text boxes that when clicked on - it will toggle on/off a criteria I have set under Actions.

Is there a way to change the colour of the box, so I have one colour when it is toggled on and another colour for when it is toggled off.

I hope this makes sense. Let me know, otherwise.

Kind Regards

Kozan

Re: Colour change to text box when clicked on

Anil_Babu_Samineni — Mon, 07 Aug 2017 15:38:24 GMT

May be you need to do this in Photoshop only. Then use those in your application

Re: Colour change to text box when clicked on

krishnacbe — Mon, 07 Aug 2017 15:42:24 GMT

Assign Variable some value like On = 1 and Off = 2.

Set the Text box color based on the Variable value like Ex. if(vColor=1,Green(), blue())

Re: Colour change to text box when clicked on

Anonymous — Mon, 07 Aug 2017 15:47:01 GMT

create a variable that gets updated when the text box is clicked on.

Like:

let vButtonColor=0

Then in your action Set External >> Set Variable

=not $(vButtonColor)

Then in your object background color select calculated and enter a formula something like

=if((vButtonColor),Red(),Blue())

Re: Colour change to text box when clicked on

tom2qlik — Mon, 07 Aug 2017 15:51:44 GMT

To do this create a variable for when a textbox is clicked.

In your textbox properties select actions and add. Select "External" from the list on the left and "Set Variable" from the list on the right then hit ok.

In the value box type the formula " =if(VariableName = 0, 1, 0) "

Next click on the general tab. Look for the button next to "Color" under background.

In the Base color area select "Calculated" and enter in the following formula into the expression box.

if(vChange=1, rgb(0,240,16), rgb(210, 210, 210))

Change the RGB values to your desired colour's.

You can apply this process to each textbox that you have and the background colour of each will change on click.

Hope this helps.

Re: Colour change to text box when clicked on

kfahri342 — Mon, 07 Aug 2017 15:53:01 GMT

I would expect the colour of the text to go back to the original colour if the User hits the clear button. This doesn't happen.

Anyway around this?

Re: Colour change to text box when clicked on

kfahri342 — Mon, 07 Aug 2017 15:55:56 GMT

I would expect the colour of the textbox to go back to the original colour if the User hits the clear button. This doesn't happen.

Anyway around this?

Re: Colour change to text box when clicked on

Anonymous — Mon, 07 Aug 2017 15:59:24 GMT

You would need to add an action at the document level to change the variable value.

On the OnAnySelect level.

something like

if(isnull(GetCurrentSelections()),vButtonColor,)

in the variable name field

and the

Value is still not $(vButton)

Re: Colour change to text box when clicked on

passionate — Mon, 07 Aug 2017 17:40:36 GMT

Hi Kozan,

There are multiple solution to your query.

1. Add action to your text box which have action for clear all

2. PFA solution.

Regards,

Pankaj

Re: Colour change to text box when clicked on

kfahri342 — Wed, 09 Aug 2017 13:26:44 GMT

Hi, I don't fully understand how to pull this off. Are you able to do some screenshot or provide a document if not too much trouble.

Apologies for my ignorance, but I am new to this.

I have managed to complete what you mentioned in your earlier post so far, but every time I hit Clear the colour still doesn't reset :

"create a variable that gets updated when the text box is clicked on.

Like:

let vButtonColor=0

Then in your action Set External >> Set Variable

=not $(vButtonColor)

Then in your object background color select calculated and enter a formula something like

=if((vButtonColor),Red(),Blue())"

Re: Colour change to text box when clicked on

kfahri342 — Wed, 09 Aug 2017 13:40:21 GMT

Bump!

Hi all, thank you for the responses so far. But unfortunately, the issue of the colour not defaulting back to the original INACTIVE colour when the USER clicks on CLEAR ALL is still an issue that I ideally need to get fixed.

I have put a quick screenshot, of the IDEAL SCENARIO which I am looking for. Along with what currently is happening.

I hope this helps

Cheers

Re: Colour change to text box when clicked on

passionate — Wed, 09 Aug 2017 14:08:28 GMT

Hi Kozan,

The attached Application does the same thing what you expect.

What action have you added to Clear all button?

Please mention what is missing in my app.

Regards,

Pankaj

Re: Colour change to text box when clicked on

kfahri342 — Wed, 09 Aug 2017 14:23:57 GMT

Thanks Pankaj.

But the function I am looking for is a Toggle rather than a Select Field. And when I switch your coding to a Toggle Action, the colour changes doesn't seem to work properly.

Unless I am missing something

Re: Colour change to text box when clicked on

Anonymous — Wed, 09 Aug 2017 14:31:57 GMT

See if this meets your need.

Pressing button switches color back and forth.

Pressing Clear will cause the button to go back to default Blue.

Re: Colour change to text box when clicked on

kfahri342 — Wed, 09 Aug 2017 14:48:58 GMT

Actually nevermind, I have figured out the variable you added on the document level. This works perfectly now. Thank you so much for your help

----

This seems to work well. Thanks. I can see the expressions and actions you have put on the object itself.

How are you making the variable default to a "-1" when I hit clear?

Re: Colour change to text box when clicked on

kfahri342 — Wed, 09 Aug 2017 15:21:46 GMT

Quick question on this. As I have a few text boxes that I need to implement this on all with there own variable.

Does this have an affect on the performance of Qlikview. As I have implemented this on a few boxes already and I am experiencing a considerable lag in performance. I wonder weather this is just my pc or the fact I have added multiple triggers on the document level?

Please let me know if you have any insight. Thanks

Kozan

Re: Colour change to text box when clicked on

Anonymous — Wed, 09 Aug 2017 15:21:57 GMT

Go in to Document Settings > Triggers

I have a Document Event Trigger on the "OnAnySelect'

Re: Colour change to text box when clicked on

Anonymous — Wed, 09 Aug 2017 15:25:34 GMT

I can't say i've ever experienced increased lag because of buttons like this.

I've only had 4 or 5 buttons on a page tied to actions though. Not sure how many you have.

And I've had a couple of dozen variables before.

Sorry I can't give a more definitive answer than that.