topic Re: color getselectedfield in QlikView

color getselectedfield

Mon, 11 Feb 2013 14:22:42 GMT

Hello, i have this expression

='Chosen Customer: ' &GetFieldSelections( DimCustomer.CustomerID)

Then my text box would look like this if i choose something from customerid:

Chosen Customer: Hulla

How can i make Hulla another color ?

So chosen customer is white and hulla is green.

ps. It is in one textbox

Re: color getselectedfield

Mon, 11 Feb 2013 14:45:21 GMT

Hi,

I'm not sure you can do it that.

Did you try with a workaround like using two textbox with two different settings for the text color ?

Hope it helps

Giampiero

P.S: If you solve your problem please share with us your solution because it's a very interesting question.Thanks

Re: color getselectedfield

Mon, 11 Feb 2013 15:28:30 GMT

i can easily use two different textboxes. But i want all in one - But i havent cracked the code yet. I will let you know when i do!

Re: color getselectedfield

marcus_sommer — Mon, 11 Feb 2013 15:34:01 GMT

Put a formula in background-color from the textbox:

if(GetFieldSelections( DimCustomer.CustomerID) = 'Hulla', green(), white())

- Marcus

Re: color getselectedfield

Gysbert_Wassenaar — Mon, 11 Feb 2013 15:40:35 GMT

You can't. It's not possible in a single text object. There is no way to have two different text formats or colors in one text object.

Re: color getselectedfield

vivientexier — Mon, 11 Feb 2013 15:48:32 GMT

Ya ! It is impossible to have different text formats in one text object... except if you...

Use the "text aera" for your customer ID and use the caption to write "Chosen Customer:". Your text aera and caption can have different fonts, size and colors. It looks nice and costs only one object .

Re: color getselectedfield

marcus_sommer — Mon, 11 Feb 2013 15:51:55 GMT

In my case it works ...

Re: color getselectedfield

Mon, 11 Feb 2013 16:30:21 GMT

thats shiat But thanks for the answer

Re: color getselectedfield

Mon, 11 Feb 2013 16:57:02 GMT

No does not work It colors the whole field, and not only the selection

Re: color getselectedfield

marcus_sommer — Tue, 12 Feb 2013 08:22:49 GMT

You want a textbox which looks like a listbox?

Perhaps a possibility is to use a pivot like this and set (optional) the column-width on 0

set chart = ActiveDocument.GetSheetObject("CH10007")

chart.SetPixWidth 2 , 0

Another possibility could be the textbox-extension from Stefan Walter - see:

http://www.qlikblog.at/1579/qliktip-39-displaying-html-content-minimalistic-htmltextbox-object-extension/

- Marcus