topic Re: Text format using valuelist in QlikView

Text format using valuelist

Fri, 13 Nov 2015 15:57:34 GMT

Hi,

I am using valuelist to create a dimension with 5 different calculated expressions in a straight table. Valuelist(Actuial,Target,LY,vs Target,vs LY)

for the vsTarget and vs LY, I would like the text to change colour based on the calculated value.

I have tried an if statement in the text format of the expression but this doesn't seem to work

Assume you have to have the if(valuelist(...) = 'vs Target' then a nested if for the calculation if((Actual-Target)/Target > 0, RGB()

Please help!?

Thanks

Michelle

swuehl — Fri, 13 Nov 2015 16:52:44 GMT

Could you upload a small sample QVW that demonstrates your issue?

In your second if() statement, are Actual and Target field names or expression labels?

Fri, 13 Nov 2015 17:09:36 GMT

Hi,

Attached

In the third column of the table I need the vs Target value to changed based on whether +ve or -ve

Hope this helps!

Cheers

Michelle

swuehl — Fri, 13 Nov 2015 17:27:36 GMT

Something like this should work:

=if(ValueList('Actual','Target','vs Target') = 'vs Target',

If( ((sum(traffic)-sum(traffic_target))/sum(traffic_target))>0, LightGreen(), LightRed()

))

Mon, 16 Nov 2015 09:15:04 GMT

Thank you!

Works perfectly