topic Another colour for a selected Value in a textbox in QlikView

Another colour for a selected Value in a textbox

francisvandergr — Tue, 14 Dec 2010 09:36:04 GMT

I have a table called Businessunit with the following values C, E, P, S , ALL. On my dasboard i first had a listbox from the field BU. But my problem is that i don't wanna see all values to select. The value 'ALL' i don't wanna see.

To achieve this i made a few Textboxes with the action "Select in field" BU with the search string C, S,E and P. Now i want one thing in my textbox. I want to have my selected text another colour when i select a value is this possible?

Another colour for a selected Value in a textbox

Tue, 14 Dec 2010 10:24:43 GMT

Hi,

In this case, I would suggest you to add caption to your Text box.

You will find it in Text box properties - Caption.

You can change color of Active and Inactive Caption as per your choice.

Happy Thoughts

Another colour for a selected Value in a textbox

marcel_olmo — Tue, 14 Dec 2010 11:10:44 GMT

Sure Francis, all you have to do is calculate the background color depending on your selection or whatever you want to do.

I've uploaded an example showing how to change the background color.

Hope it helps!!

Another colour for a selected Value in a textbox

Tue, 14 Dec 2010 11:19:23 GMT

Hello Francis,

did you try to create an expression within your listbox ? Here is my example:

=if( BU<> 'ALL', BU)

Regards, Roland

Another colour for a selected Value in a textbox

francisvandergr — Tue, 14 Dec 2010 11:26:44 GMT

In a listbox you can use an expression? I see not on which tab and field i can do that.

Another colour for a selected Value in a textbox

Tue, 14 Dec 2010 11:33:06 GMT

Yes.

General Tab --> Field input --> search a little bit (it is the first entry of the drop down list and called <expression> ). The rest should be easy.Don't forget the "=" at the begining of your expression.

Another colour for a selected Value in a textbox

maneshkhottcpl — Tue, 14 Dec 2010 12:07:30 GMT

Hi, Can u explain me in details. if possible please send me sample application.

Another colour for a selected Value in a textbox

francisvandergr — Tue, 14 Dec 2010 12:37:05 GMT

Thanx i found it