topic Color-coding Matrix chart, odd behavior. in QlikView

Color-coding Matrix chart, odd behavior.

Thu, 18 Jun 2015 10:48:00 GMT

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.'

m_woolf — Thu, 18 Jun 2015 12:21:25 GMT

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

Thu, 18 Jun 2015 12:38:12 GMT

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

stigchel — Thu, 18 Jun 2015 12:42:58 GMT

$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")