topic Re: Changing Text Object Color with Multiple Select in Field in QlikView

Changing Text Object Color with Multiple Select in Field

rustyfishbones — Fri, 04 Oct 2013 09:05:18 GMT

Hi All,

I have the following expression

I have a Text object with an Action of Select in Field, and it looks like this

But when I click the Text Object to select the fields, the background color should turn to the $(color.green)

but it does not seem to be working

Any help would be great

Re: Changing Text Object Color with Multiple Select in Field

sujeetsingh — Fri, 04 Oct 2013 09:13:01 GMT

Just to check call this variable color.green in another text box and then see it value .

clarify the value is what you want .

Whether you want the color to come ,where you have written this expression .

Can you please send a sample .

Re: Changing Text Object Color with Multiple Select in Field

tresB — Fri, 04 Oct 2013 09:13:11 GMT

Try removing the double quotes in the search string like:

(.P|.R|.I|.W|.D|.WRX)

Re: Changing Text Object Color with Multiple Select in Field

rustyfishbones — Fri, 04 Oct 2013 09:17:12 GMT

I have tried both of those suggestions but with no luck.

It will select the fields (.P|.R|.I|.W|.D|.WRX) perfectly

bjut the color just wont change, It's working for all other Select in Fields when I am selecting a single value.

So it must be something else

Regards

Alan

Re: Changing Text Object Color with Multiple Select in Field

tresB — Fri, 04 Oct 2013 09:34:17 GMT

You have to modify the expression for background color like:

If(GetFieldSelections(File,'|')='(.P|.R|.I|.W|.D|.WRX)' , greeen(), white())

Re: Changing Text Object Color with Multiple Select in Field

Fri, 04 Oct 2013 10:03:42 GMT

Hi,

Try like this

If(GetFieldSelections(File,'|')='(.P|.R|.I|.W|.D|.WRX)' , RGB(0,0,0),RGB(255,255,0))

Re: Changing Text Object Color with Multiple Select in Field

rustyfishbones — Fri, 04 Oct 2013 10:28:35 GMT

Hi guys,

I have tried your suggestions but it's still now working

I will try post a sample

Re: Re: Changing Text Object Color with Multiple Select in Field

rustyfishbones — Fri, 04 Oct 2013 10:45:30 GMT

Hi Guys,

here is a sample file.

As you wil see, the button for 'All' selects the correct fields but does not turn blue like the other 2 buttons when they are selected

Hope you can help

Regards

Alan

Re: Re: Re: Changing Text Object Color with Multiple Select in Field

jagannalla — Fri, 04 Oct 2013 11:12:21 GMT

Please check the attached file..

Just use the condition as

=if(WildMatch(GetFieldSelections(File,'|'),'(.P|.R|.I|.W|.D|.WRX)'),Blue(),Green())

Hope it helps you

Cheers!!

Jagan

Re: Re: Re: Changing Text Object Color with Multiple Select in Field

rustyfishbones — Fri, 04 Oct 2013 11:17:37 GMT

Hi All,

That works, thanks for your help guys

Alan

Re: Re: Re: Changing Text Object Color with Multiple Select in Field

rustyfishbones — Fri, 04 Oct 2013 11:38:36 GMT

Hi Jagan,

One final question, how can I get the color to change for the excluded files

so I have select in field (.P|.R|.I|.W|.D|.WRX) and then Select Excluded

but how to get a new button to change color for all selections not in (.P|.R|.I|.W|.D|.WRX)

Thanks

Alan

Re: Changing Text Object Color with Multiple Select in Field

Fri, 04 Oct 2013 11:39:54 GMT

Allan;

Try changing the expression of the action "select field" to:

(. P |. I) without the double quotes

Re: Changing Text Object Color with Multiple Select in Field

Fri, 04 Oct 2013 11:42:31 GMT

inverting the expression passed by Jagan

= if (not WildMatch (GetFieldSelections (File, '|'), '(. P |. R |. I |. W |. D |. WRX)'), blue (), green ())

Re: Changing Text Object Color with Multiple Select in Field

rustyfishbones — Fri, 04 Oct 2013 11:48:15 GMT

Thanks Claudio,

That works fine

I have used NOT WILDMATCH before, I just tend to forget these things if I have not used them in a while

Thanks again

Re: Changing Text Object Color with Multiple Select in Field

jagannalla — Fri, 04 Oct 2013 11:51:35 GMT

U can go with Claudio expr for exclude values

Re: Changing Text Object Color with Multiple Select in Field

rustyfishbones — Fri, 04 Oct 2013 11:58:24 GMT

Thanks Jagan.

However, although it does color the background based on the NOT part being added

It also continues to highlight if I select some of the other buttons

see below example, I selected .wrx, but it also highlights aof.

If I select aof first it's fine, but if I select .P|.R|.I|.W|.D|.WRX it also highlights aof

Re: Re: Changing Text Object Color with Multiple Select in Field

Mon, 07 Oct 2013 12:56:09 GMT

See the attachement.