# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save \$400. Learn More
Highlighted
Contributor II

## Counting If between numbers

Hi All,

I am using a straight table and trying to multiple two columns and add background colour based on the results.

The expression is Maths * English

In the "Background Colour" Section under expressions, I added,

=IF(Maths * English>12, LightRed(),
if(Maths * English<=12 and if(Maths * English>=8, LightMagenta()), LightGray())).

The first If works (>12 changes to LightRed()). However, LightGray() appears for the second category, i.e., values between 8 and 12. LightMagenta does not appear anywhere. Values below 8 has no background colour, appears in white. What am I doing wrong please?

Regards,

Karthik

Tags (1)
1 Solution

Accepted Solutions
MVP

## Re: Counting If between numbers

Hi Karthik, try with this:

=IF(Maths * English>12, LightRed(),

if(Maths * English>=8, LightMagenta(), LightGray())).

2 Replies
MVP

## Re: Counting If between numbers

Hi Karthik, try with this:

=IF(Maths * English>12, LightRed(),

if(Maths * English>=8, LightMagenta(), LightGray())).

Contributor II

## Re: Counting If between numbers

Hi Ruben,

Yes, it works. Thank you very much!