topic Re: How to change expression color in text and Image box? in QlikView

How to change expression color in text and Image box?

millan123 — Wed, 07 Sep 2016 11:12:28 GMT

Hello All,

I have a temp date ,when I was showing in text box the condition should be if the date is less then today that would be red or Equal/greater that should be black..

06/09/2016 is Temp date, the out put will be as 06/09/2016

07/09/2016 is Tem date, then the out put will be as 07/09/2016\

Please help me on this

Thanks in advance!

Re: How to change expression color in text and Image box?

kristof_j — Wed, 07 Sep 2016 11:19:00 GMT

go to the properties Font tab

Click on the color

Select 'Calculated'

and then add the expression

if(Tempdate < Today(), rgb(250,0,0))

Re: How to change expression color in text and Image box?

dmac1971 — Wed, 07 Sep 2016 11:19:01 GMT

Like this Clark. !

When you add your date dimension click the + beside it. Double click Text Colour and add in :

=if(Date<=Today(),Red())

Then apply. Change "Date" to match your dimension. Example file included has this done. Any questions just shout!

Re: How to change expression color in text and Image box?

jsingh71 — Wed, 07 Sep 2016 11:22:13 GMT

Go to font tab for the Text Box and click on color.

After that under calculate write following expression:

if(Date(TempDate,'DD/MM/YYYY') <= Date(Now(),'DD/MM/YYYY'), Red(),Black())

Replace TempDate with your Date field but be careful your DateField should be contain only one value bcz you are showing date on text box.

Re: How to change expression color in text and Image box?

Anonymous — Wed, 07 Sep 2016 11:23:54 GMT

Text object Properties>Font>Color>Calculated : If(TempDate<today(),Red(),Black())

Hope it helps!!

Re: How to change expression color in text and Image box?

millan123 — Wed, 07 Sep 2016 11:26:34 GMT

Thanks, but I need that in Qliksense

Re: How to change expression color in text and Image box?

Anonymous — Wed, 07 Sep 2016 11:30:08 GMT

may be helpful for you?

can a text box in Qlik Sense be given conditional font colour settings?

color by expression - QlikSense