use Color Area-calculated

[#1]

hi all.

I want some part of list be a red color.

ex.

the field name= test

content =

I made a list box by using Test.xlsx.

and I want highlight some part (words that begin with 'a')

what do i write edit Expression( on Calculated)

[jonathandienst]

Hi

Is the field name [Calculated]?You could try

     If(WildMatch(Calculated, 'a*'), Red())

But I don't its possible to vary the colour in a list box.

HTH

Jonathan

[#3]

Hi, Jonathan.

I wrote 'If(WildMatch(Test, 'a*'), Red())

that's not working.....

and also use this

=if(Test like 'a%', RED(), GREEN())

thank you.

[jonathandienst]

The first syntax is correct, but as I said, I think the calculated colour is ignored in a list box. Your second syntax is SQL, not QV and won't work in an expression.

[#5]

Hi,

You can write an expression like:

=If(WildMatch(AA, 'a*'), Red(),

  If(WildMatch(AA, 'b*'), Green()

))

And so on...for all the selections you want.

But this will change the entire background colour of list box and will work only when the value is selected i.e. the colour will appear only when you select something starting with a or b (individually and not combinely).

[#6]

so, you mean

It's impossible partially different colors on a list box (no selection situation).

Test(list box)

apple

air

apartment

bi

banana

clear

[#7]

really?

I don't know that SQL not working.

thank you.

[#8]

Hi,

You can change text colour but still the selection situaton prevails.

For changing the text color instead of background, you just need to change the check box style anything other than "Qlikview Classic" in presentation tab:

After changing style to anything other than "Qlikview Classic" or "User Default", you can go to font tab and change the font colour using the calculation i mentioned earlier.

[marc_behrens]

Hi, would something like this work for you?

Marc

[jonathandienst]

The SQL prefix (as in SQL SELECT...) in the load script sends the text following it to the SQL server for execution - it is not executed by QV. So you must use SQL syntax in a SQL SELECT or SQL EXECUTE clause.Everywhere else requires QV syntax (including LOAD statements and obviously in expressions).