topic Re: Colors written in expression in Visualization and Usability

Colors written in expression

Wed, 15 Jun 2016 14:14:35 GMT

Hello,

I have the following formular running to get a "delay" and "in time" result:

=if(
( NetWorkDays( ( E_WE_Pos.c_Liefertermin), (E_WE_Pos.c_WE_Datum))-1) >2 ,
'delay', 'in time' )

Its working fine but now I want to have the word "delay" written in RED and "in time" written in GREEN color. Could someone help me if there is an easy way to include the colors directly in the code that I get the result promplty?

Thx & regards

Heiko

Re: Colors written in expression

swuehl — Wed, 15 Jun 2016 15:19:23 GMT

As expression for text coloring (in properties of your table chart for your expression), use something like

=if( ( NetWorkDays( ( E_WE_Pos.c_Liefertermin), (E_WE_Pos.c_WE_Datum))-1) >2 ,

Lightred(),

Lightgreen()

)

Re: Colors written in expression

Thu, 16 Jun 2016 06:04:29 GMT

Hello,

thx for your infirmation. I guess it doesn't give me the result. I understood that this expression works fine if I use that to format a dimension directly.

Th idea is to implement the color directly in the expression that the result comes back in the requested color like:

=if(( NetWorkDays( ( E_WE_Pos.c_Liefertermin), (E_WE_Pos.c_WE_Datum))-1) >2 ,

red() 'delay',

green() 'in time' )

I tried the a.m. version but it doesn't work in theis direction.

Heiko

Re: Colors written in expression

swuehl — Thu, 16 Jun 2016 09:26:27 GMT

Have you tried setting the text color expression within your expression properties section in properties panel of your QlikSense table chart?

Re: Colors written in expression

nizamsha — Thu, 16 Jun 2016 10:17:37 GMT

In Table ,under the measure in that you have the option Background Color Expression

if( ( NetWorkDays( ( E_WE_Pos.c_Liefertermin), (E_WE_Pos.c_WE_Datum))-1) >2 ,

red(),

green()

)

Re: Colors written in expression

Thu, 16 Jun 2016 14:43:15 GMT

Hello ,

thx for the input. it works now.