topic Re: use Color Area-calculated in QlikView

use Color Area-calculated

Mon, 25 Nov 2013 07:49:12 GMT

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)

Re: use Color Area-calculated

jonathandienst — Mon, 25 Nov 2013 08:16:25 GMT

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

Re: use Color Area-calculated

Mon, 25 Nov 2013 08:19:51 GMT

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.

Re: use Color Area-calculated

jonathandienst — Mon, 25 Nov 2013 08:25:06 GMT

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.

Re: Re: use Color Area-calculated

Mon, 25 Nov 2013 08:27:26 GMT

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).

Re: Re: Re: use Color Area-calculated

Mon, 25 Nov 2013 08:39:54 GMT

so, you mean

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

Test(list box)

apple

air

apartment

banana

clear

Re: Re: Re: use Color Area-calculated

Mon, 25 Nov 2013 08:40:59 GMT

really?

I don't know that SQL not working.

thank you.

Re: use Color Area-calculated

Mon, 25 Nov 2013 09:29:51 GMT

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.

Re: Re: Re: Re: use Color Area-calculated

marc_behrens — Mon, 25 Nov 2013 09:37:56 GMT

Hi, would something like this work for you?

Marc

Re: use Color Area-calculated

jonathandienst — Mon, 25 Nov 2013 11:57:31 GMT

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).

Re: use Color Area-calculated

Tue, 26 Nov 2013 00:32:40 GMT

Hi,

Ummm.. yes, but already I set checkbox in list box.

after that, want show highlight 'bold'character begin with 'A' on list box.

I think its hard to present following my intention..

thank you.