Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
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")