topic Re: Colour in an Expression in QlikView

Colour in an Expression

dinicholls — Wed, 14 Jan 2015 11:06:39 GMT

Hi,

I have an expression in my QV app, and this might sound a bit simple, but I want the result in my pivot table to be red, if less than 0, and black if not.

I know about the '+' sign next to the expression name, but have never really used it.

If I wanted to do the above, would I have to repeat my expression in the 'Text Colour' field, or can I just add in <0, Red(), black().

This if my formula in my expression field:

if(Company=29,(sum([Line Debt])/100*$(Medical)),

if(Company='100D',(sum([Line Debt])/100*$(Pest)),

if(Company='100K',(sum([Line Debt])/100*$(Wash)),

if(Company='100F',(sum([Line Debt])/100*$(Hygiene)),

if(Company='100Z',(sum([Line Debt])/100*$(Ambius)),0)))))

Thanks

Re: Colour in an Expression

Anonymous — Wed, 14 Jan 2015 11:11:44 GMT

Just adding in <0, Red(), black() should suffice.

Give it a go and tell us whether or not you have success.

Re: Colour in an Expression

yduval75 — Wed, 14 Jan 2015 11:16:52 GMT

Use visual cue tab and put a color if lower than 0

Re: Colour in an Expression

Wed, 14 Jan 2015 11:21:50 GMT

Hi DiNicholls,

Here you must have to write expression in the background color which appears when you click on the + sign.

Expression to be written is if(Line<0,Red(),Black()) where Line is the Label of you expression.

Please fine the screen shot for the same.

Re: Colour in an Expression

richard_chilvers — Wed, 14 Jan 2015 11:24:22 GMT

Hi Diane

Visual Cues in Properties work best for simple highlighting. I think this will work OK for you. Otherwise the '+' gives more variety (eg. cell background) but sometimes you need to hunt around for documentation on how best to use the features (eg. bold font). This community is a good source.

Re: Colour in an Expression

dinicholls — Wed, 14 Jan 2015 11:30:03 GMT

Thank you all!

Didn't realise it was that simple!

Re: Colour in an Expression

Wed, 14 Jan 2015 11:52:45 GMT

Its ok. The more we post, More we learn.