Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
go to the properties Font tab
Click on the color
Select 'Calculated'
and then add the expression
if(Tempdate < Today(), rgb(250,0,0))
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!
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.
Hi
Text object Properties>Font>Color>Calculated : If(TempDate<today(),Red(),Black())
Hope it helps!!
Thanks, but I need that in Qliksense