topic Font color and style for Expression Column value in QlikView

Font color and style for Expression Column value

Tue, 20 Jan 2015 04:59:19 GMT

Hi,

I have sum(Amounts) column as a Expression. My requirement is,

if sum(Amounts) has negative value , that negative value should be Red Color and that negative value in brackets like ( ).

How can i achieve this, could you please tell me Set expression and process

Thanks,

MLNR

Re: Font color and style for Expression Column value

jagan — Tue, 20 Jan 2015 05:35:25 GMT

Hi,

Use this as expression

=Num(Sum(Sales), '#,##0.00;(#,##0.00)')

and in number table select Expression Default option.

and for background color expand + sign of the expression and click on Background and give below expression

=If(Sum(Sales) > 0, RGB(255, 0, 0))

Hope this helps you.

Regards,

Jagan.

Re: Font color and style for Expression Column value

senpradip007 — Tue, 20 Jan 2015 05:36:57 GMT

Try this

if(sum(Amounts) >=0, sum(Amounts), '(' & sum(Amounts) &')' )

Expend expressions and write the following expression "Background Color" section for background

if(sum(Amounts) <0, red(), black())

Re: Font color and style for Expression Column value

Tue, 20 Jan 2015 05:53:02 GMT

Hi Jagan,

Thi expression is ok. But I want , negative number color is in red and negative number should be in brackets like ( ).

Thanks

MLNR

Re: Font color and style for Expression Column value

Tue, 20 Jan 2015 05:53:31 GMT

Hi Pradip,

Thi expression is ok. But I want , negative number color is in red and negative number should be in brackets like ( ).

Thanks

MLNR

Re: Font color and style for Expression Column value

sunilkumarqv — Tue, 20 Jan 2015 06:32:39 GMT

Make use Expression as Num(sum(Amount),'#,##.#;(#,##.#) ; '))

and then go to + sign background expression

IF(Sign(Amount)='-1',Red())

Re: Font color and style for Expression Column value

senpradip007 — Tue, 20 Jan 2015 06:50:02 GMT

Have you tried it?

Re: Font color and style for Expression Column value

jagan — Tue, 20 Jan 2015 06:55:21 GMT

Hi,

For coloring try like this

For Text color expand + sign of the expression and click on Text Color and give below expression

=If(Sum(Sales) > 0, RGB(255, 0, 0))

Regards,

Jagan.

Re: Font color and style for Expression Column value

senpradip007 — Tue, 20 Jan 2015 07:17:19 GMT

Have a look on the attachment.

Re: Font color and style for Expression Column value

Anonymous — Tue, 20 Jan 2015 07:17:35 GMT

Hi Narayana ,

Pradip Sen suggested is working

Re: Font color and style for Expression Column value

krishna20 — Tue, 20 Jan 2015 07:27:28 GMT

hi,

Try this link, It may helps

Need to convert Negative values to positive values with[ ] and red font

Regards

Krishna

Re: Font color and style for Expression Column value

krishna20 — Tue, 20 Jan 2015 07:31:42 GMT

Hi,

Goto properties -> Number Tab-> Select your Expression-> Select Integer -> In Format Pattern replace this #,##0;(#,##0)

Then

Goto Expression Tab-> Select your Expression -> Expand it by + mark. Select Text Format.Then write like this

if(sum(Sales)>=0,bllack(),Red())

Hope this helps

Regards

Krishna

Re: Font color and style for Expression Column value

senpradip007 — Wed, 21 Jan 2015 04:16:40 GMT

You should close the discussion, if reached the goal, by choosing one correct or helpful answer for others to learn.

Re: Font color and style for Expression Column value

gautik92 — Wed, 21 Jan 2015 05:32:08 GMT

You can also set flag for it by using this formula

If(Sum(Sales) <= 0,'qmem://<bundled>/BuiltIn/arrow_s_r.png','qmem://<bundled>/BuiltIn/arrow_n_g.png')

And select the expression and choose image and select keep aspect