How to change expression color in text and Image box?

[millan123]

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!

[kristof_j]

go to the properties Font tab

Click on the color

Select 'Calculated'

and then add the expression

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

[dmac1971]

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!

[jsingh71]

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.

[Anonymous]

Hi

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

Hope it helps!!

[millan123]

Thanks, but I need that in Qliksense

[Anonymous]

may be helpful for you?

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

color by expression - QlikSense