topic Change background cell color in the chart table in QlikView

Change background cell color in the chart table

Thu, 16 Sep 2010 00:01:48 GMT

I have an expression to change background color of a cell on

=If([Technology Status]='AAA',lightgreen()) -

works fine but I do have multiple statuses so I want to color them in different colors.

Such as:

=If([Technology Status]='XYZ',lightblue()) and

=If([Technology Status]='xxx',red()) and so on

How do I use nested if or is there any better way? Thanks, yury

Change background cell color in the chart table

Thu, 16 Sep 2010 00:19:14 GMT

I don't have access to QV at the moment but dont forget how the 'if' statement is constructed:

if (conditional statement, true, false)

so you nest an if like:

If([Technology Status]='AAA',lightgreen(), If([Technology Status]='XYZ',lightblue(), if (......)))

Regards,

Gordon

Change background cell color in the chart table

Thu, 16 Sep 2010 16:07:36 GMT

I tried this, does not work, even the first if stoped working.

Change background cell color in the chart table

tabletuner — Thu, 16 Sep 2010 16:26:30 GMT

are you sure you wrote the expression in the expanded part of the expression (push the '+') called 'Background color'?

Just writing this in the normal expression wont work.

Change background cell color in the chart table

Thu, 16 Sep 2010 16:34:18 GMT

Yes, it is an expression of a Background color

Change background cell color in the chart table

googel84 — Thu, 16 Sep 2010 16:36:23 GMT

Hi ypritzke, look at my piece of code. It works fine to me.

if( Status = 'Completed',
 green(),
 if( Status = 'Completed with warning',
 yellow(),
 if( Status = 'Completed with errors',
 red(),
 if( Status = 'Not planned',
 RGB(255,100,0),// arancione
 if( Status = 'Not started',
 red(),
 white()
 )
 )
 )
 )
 )

Change background cell color in the chart table

Thu, 16 Sep 2010 16:48:25 GMT

Thank you. it worked. I did not have very last altrenative like white() in your case

Change background cell color in the chart table

Thu, 16 Sep 2010 17:07:09 GMT

Well done. I liked it.

ERP Consulting
SAP ERP Consultants

Change background cell color in the chart table

johnw — Thu, 16 Sep 2010 19:47:59 GMT

Another option:

pick(match("Technology Status",'AAA' ,'XYZ' ,'xxx',...)
lightgreen(),lightblue(),red(),...)

And another:

StatusColors:
LOAD * INLINE [
Technology Status,R,G,B
AAA,50,255,50
XYZ,50,50,255
xxx,200,0,0
...
];

rgb(R,G,B)

Re: Change background cell color in the chart table

quiquehm — Sun, 04 Jun 2017 15:46:48 GMT

Hi John,

I am interested in your inline table for background coloring. I have a large table of activities which need to have a different color for every activity ( fixed colors by activities ), and using nested if in the expression causes the app to run very very slow . I guess your solution of the inline table in the script will make the app to run better. What expression do you enter for the background color ? just this one ?: =RGB(R,G,B) ?

THANKS

Re: Change background cell color in the chart table

sergio0592 — Sun, 04 Jun 2017 16:22:03 GMT

Hi Enrique,

You must write the name of the color field. In my exemple below, the name of the field color is JudgColor.

JudgmentsColors:

LOAD *

,rgb(R,G,B) as JudgColor

INLINE [

Judgments,R,G,B

critical,255,28,28

major, 255,255,45

minor,0,128,255

];

Re: Change background cell color in the chart table

quiquehm — Wed, 07 Jun 2017 19:58:05 GMT

Thank you Jean ! I tried it and it works perfect !

rgds

Enrique