Text Color Change in Table

[#1]

I am new to Qlikview & using Qlikview 10.I have a table in which i have a Sales Column(Numeric Value) & on the basis of it i have made a new Calculated Column by making use of the following Condition--

If(Sum(Sales)>50,'Good',If(Sum(Sales)<=50,'Bad')).

I want to change the Color of Text of this Column by making use of a condition that-

Good---It Should come Green

Bad-----It should come Red.

What should be the Proper Condition & where to write it.I have attached the sample Qvd also.I want to change the Color of Text Only not the Background Color

Thanks in Advance.....!

[Anonymous]

If you expand the expression you can set another expression for text color and use:

If(Sum(Sales)>50,LightGreen(),If(Sum(Sales)<=50,LightRed()))

[sivarajs · Accepted solution]

Expand the expression and click on text color and give expression

Check the file

[#4]

Ya It works for Me.

Thanks Sivaraj & Johannes for your quick Response...

[#5]

Hi All,

That is working fine

I just want to know how can i change the font of 'Bad' and 'Good'.

I want them in Bold format.

Thanks

Akrati

[#6]

Hi Akrati,,

Goto 'Settings' menu, then 'User Preferences', 'Design', and check the option 'Always Show Design Menu Items'.

Next; goto the chart or table where you want to change the font settings and right click on the column of interest.

You will have an option "Custom Format Cell" click that and change the "Text Size" in % terms with respect to its adjacent columns.

You can apply a variety of text formatting options available.

                                                          OR

Go to the properties of the chart/Table in which you want to change the font.

Select the Text format option of that column .Then use   ='<B>'     for Bold text format.

Hope it helps.

Thanks,

Manoj

[sivarajs]

Right click on column you want to change --> custom format cell --> Text Setting --> Change to bold

[#8]

Thanks all...

It works......