https://community.qlik.com/t5/Reporting-Service-Alerting/How-to-write-a-expression-for-background-color-in-Qlikview/m-p/2025136#M494 <P>=if ((min(if([Service.Service Code Raw] = 'H0004' ,[Service Payor.Date of Service]))) <BR />-<BR />max(if([Service.Service Code Raw] = 'H0046' ,[Service Payor.Date of Service]))&nbsp; )&nbsp; &gt; 7, green().</P> <P>&nbsp;</P> <P>I am using above expression. But its giving me error for if statement. please help.&nbsp;</P> Fri, 15 Nov 2024 21:52:05 GMT kiara 2024-11-15T21:52:05Z https://community.qlik.com/t5/Reporting-Service-Alerting/How-to-write-a-expression-for-background-color-in-Qlikview/m-p/2025136#M494 <P>=if ((min(if([Service.Service Code Raw] = 'H0004' ,[Service Payor.Date of Service]))) <BR />-<BR />max(if([Service.Service Code Raw] = 'H0046' ,[Service Payor.Date of Service]))&nbsp; )&nbsp; &gt; 7, green().</P> <P>&nbsp;</P> <P>I am using above expression. But its giving me error for if statement. please help.&nbsp;</P> Fri, 15 Nov 2024 21:52:05 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/How-to-write-a-expression-for-background-color-in-Qlikview/m-p/2025136#M494 kiara 2024-11-15T21:52:05Z https://community.qlik.com/t5/Reporting-Service-Alerting/How-to-write-a-expression-for-background-color-in-Qlikview/m-p/2025185#M497 <P>Try this nested 'if' statement format</P> <P><A href="https://community.qlik.com/t5/New-to-Qlik-Sense/Nested-IF-Statements/td-p/1022597" target="_blank">https://community.qlik.com/t5/New-to-Qlik-Sense/Nested-IF-Statements/td-p/1022597</A></P> Thu, 12 Jan 2023 20:46:56 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/How-to-write-a-expression-for-background-color-in-Qlikview/m-p/2025185#M497 Frank_S 2023-01-12T20:46:56Z