Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Color-coding Matrix chart, odd behavior.

Hi,

I'm trying to display certain values in a matrix diagram.

I've got the value s3_leak

and different tolerance values that I'm trying to color-code.


I've tried so far to change the background-color with this if statement:

"if(s3_leckage_r << 20 OR s3_leckage_r >> 80, red(), green())"

So this should color all values outside of that range in red, and those within the tolerance should be displayed green.

However the end result is that only values = 0 are green while the rest is red. (see screenshot)


Any help would be appreciated.'

1 Solution

Accepted Solutions
m_woolf
Master II
Master II

I don't know what << means, but it doesn't mean less than. When I put =4<<5 in a text box, it returns 128.

Try just using s3_leckage_r < 20 OR s3_leckage_r > 80

View solution in original post

3 Replies
m_woolf
Master II
Master II

I don't know what << means, but it doesn't mean less than. When I put =4<<5 in a text box, it returns 128.

Try just using s3_leckage_r < 20 OR s3_leckage_r > 80

Not applicable
Author

Changed the operator to a single '>', that did the trick. Thank you very much!

stigchel
Partner - Master
Partner - Master

$a << $b Shift left Shift the bits of $a $b steps to the left (each step means "multiply by two")

$a >> $b Shift right Shift the bits of $a $b steps to the right (each step means "divide by two")