Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Mamta123
Contributor II
Contributor II

Conditional formatting with a number of conditions

The below formula doesnot work

=if(Num(Avg(Age) >= 10, Green(),Red())

also I need to add And/Or statement to this :

if brand is 'A' or 'B' and Avg (age)>10 then green else blue

and if the brand is other than 'A' or 'B' and avg(age) > 80 , then green else blue

This is very complex. Can someone help me with conditional formatting

 

 

0 Replies