Qlik Community

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
infock12
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

Re: Counting If between numbers

Hi Karthik, try with this:

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

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

View solution in original post

2 Replies

Re: Counting If between numbers

Hi Karthik, try with this:

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

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

View solution in original post

infock12
Contributor II

Re: Counting If between numbers

Hi Ruben,

Yes, it works. Thank you very much!