Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I'm still very new to QV but want to build a little app where the text object changes colour based on a value I get from a excel file. For example: If the value is less than 50, the colour must be red and above 50 it must be green.
Any help will be appreciated!!
Thanks,
Eon
Hi, This could be done by writing a simple code in 'Text Color' property of an expression.
The code is:
=If(value>50,Green(),Red())
Hi, This could be done by writing a simple code in 'Text Color' property of an expression.
The code is:
=If(value>50,Green(),Red())
Hi Amit
Thanks for your quick reply!! CAn you please explain what you mean by expression? When I right click on the text object there is only the actions tab where I can enter some code.... Where do you sugggest I put this code?
Sorry, I'm very new to QV!
Thanks,
Eon
Hi Eon,
I think what Amit is describing is the following (I am using 8.5 SR5):
Hope this is of some help.
Rod
Thanks!
Has anybody any idea how to do this with Qlikview 11.0?