topic Re: Visual efects with strings? in QlikView

Visual efects with strings?

Fri, 16 Jan 2015 14:53:54 GMT

Hi i have an if/else condition and for result i have

"Ok"

"No Ok"

etc...

I tried in the vissual part efects and it works with numbers but i couldn't do this with the strings

it would be something like

IF(Status = 'Ok', Red(), Green()) or something like this

Greetings

Re: Visual efects with strings?

NickHoff — Fri, 16 Jan 2015 14:57:51 GMT

You have to use double quotes:

IF(Status = 'Ok', "Ok","No Ok") AS Status

Re: Visual efects with strings?

consenit — Fri, 16 Jan 2015 15:02:58 GMT

Hi there.

I never use visual effects because it's an obsolete feature; it's far better to enter the formula for color calculation below the main formula in the "Expression" tab, check out the treeview at the left side.

Kind regards,

Ernesto.

Re: Visual efects with strings?

Fri, 16 Jan 2015 15:13:21 GMT

Thank ya.