https://community.qlik.com/t5/App-Development/If-statement-and-color-expression/m-p/1701628#M53734 <P>May be this</P><LI-CODE lang="markup">If(Max(crmDATE) &gt;= today(), RGB(0,255,0), If(Max(crmDATE) = Today() - 1, Yellow(), RGB(255,0,0)))</LI-CODE> Wed, 13 May 2020 14:48:25 GMT sunny_talwar 2020-05-13T14:48:25Z https://community.qlik.com/t5/App-Development/If-statement-and-color-expression/m-p/1701618#M53733 <P>I am attempting to format the background color of measure if my chart. The current expression I am using is:</P><P>=if(Max(DATE(crmDATE)) &gt;= today(), rgb(0,255,0), rgb(255,0,0)) returning green if the date is greater than today or red if anything else. I want to introduce a third variable of returning the background of yellow if the maxdate is today -1. How can I introduce this into my equation?</P> Sat, 16 Nov 2024 18:39:03 GMT https://community.qlik.com/t5/App-Development/If-statement-and-color-expression/m-p/1701618#M53733 evansabres 2024-11-16T18:39:03Z https://community.qlik.com/t5/App-Development/If-statement-and-color-expression/m-p/1701628#M53734 <P>May be this</P><LI-CODE lang="markup">If(Max(crmDATE) &gt;= today(), RGB(0,255,0), If(Max(crmDATE) = Today() - 1, Yellow(), RGB(255,0,0)))</LI-CODE> Wed, 13 May 2020 14:48:25 GMT https://community.qlik.com/t5/App-Development/If-statement-and-color-expression/m-p/1701628#M53734 sunny_talwar 2020-05-13T14:48:25Z