Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
kiara
Contributor II
Contributor II

How to write a expression for background color in Qlikview

=if ((min(if([Service.Service Code Raw] = 'H0004' ,[Service Payor.Date of Service])))
-
max(if([Service.Service Code Raw] = 'H0046' ,[Service Payor.Date of Service]))  )  > 7, green().

 

I am using above expression. But its giving me error for if statement. please help. 

Labels (1)
1 Reply
Frank_S
Support
Support

Try this nested 'if' statement format

https://community.qlik.com/t5/New-to-Qlik-Sense/Nested-IF-Statements/td-p/1022597

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!