topic Re: Red Amber else Default in QlikView

Red Amber else Default

bobbydave — Tue, 27 Jan 2015 11:38:52 GMT

I am writing some code at the moment to say that

When a value is higher than its target, the value turns green and when a value is less than its target, value turns red.

But what if there is no target, the values should stay default (black).

=if(

(if(Unit = '%', num(avg([Value]), '#,##0%'),

if(Unit = 'Days', num(avg([Value]), '#,##0'),

num(sum(Target), '#,##0'))))

(if(Unit = '%', num(avg(Target), '#,##0%'),

if(Unit = 'Days', num(avg(Target), '#,##0'),

num(sum(Target), '#,##0')))),

vGreen, vRed)

Is there a way of adding if target is blank, the values stay black

Target	Value	Value
5	7	3
6	3	8
	7	7

Re: Red Amber else Default

alexandros17 — Tue, 27 Jan 2015 11:42:54 GMT

something like this:

=If(IsNull(sum(Target), rgb(255,255,255),

if(

(if(Unit = '%', num(avg([Value]), '#,##0%'),

if(Unit = 'Days', num(avg([Value]), '#,##0'),

num(sum(Target), '#,##0'))))

>=

(if(Unit = '%', num(avg(Target), '#,##0%'),

if(Unit = 'Days', num(avg(Target), '#,##0'),

num(sum(Target), '#,##0')))),

vGreen, vRed)
)

Re: Red Amber else Default

bobbydave — Tue, 27 Jan 2015 13:47:55 GMT

Doesnt seem to like that.

Re: Red Amber else Default

alexandros17 — Tue, 27 Jan 2015 14:03:42 GMT

just manage the first expression

If(IsNull(sum(Target),

Re: Red Amber else Default

giakoum — Tue, 27 Jan 2015 14:18:39 GMT

why don't you use visual cues?