
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.'
- Tags:
- new_to_qlikview
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Changed the operator to a single '>', that did the trick. Thank you very much!


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
$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")
