topic Re: Expressions format in QlikView

Expressions format

Wed, 05 Aug 2015 09:31:33 GMT

Hi everyone!

Could you, please, refer me to any post or materials where it is reveaeld how to work with this the followwing part of expressions:

For example, I need to change a text color of only one series in diagramme not changing others.

Many thanks in advance!

Marina

Re: Expressions format

Anonymous — Wed, 05 Aug 2015 09:41:49 GMT

goto textcolor under your Expression and define

if (myserie='ABC', rgb(255,0,0), rgb(0,,0,255))

you can use variable for Colors (recommended)

Re: Expressions format

kuczynska — Wed, 05 Aug 2015 09:51:51 GMT

You can either change it use it rgb() function under Expression tab:

Or you can try to apply your changes under Visual Cues for the specified expression:

Try few options and see if that's what you are looking for. I like to use Text format option and Background Color as you have more options with the cell formatting - by using IF statements.