Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Text Color Change in Table

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.....!

1 Solution

Accepted Solutions
sivarajs
Specialist II
Specialist II

Expand the expression and click on text color and give expression

Check the file

View solution in original post

7 Replies
jsn
Master
Master

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
Specialist II
Specialist II

Expand the expression and click on text color and give expression

Check the file

View solution in original post

Not applicable
Author

Ya It works for Me.

Thanks Sivaraj & Johannes for your quick Response...

Not applicable
Author

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

Not applicable
Author

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
Specialist II
Specialist II

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

Not applicable
Author

Thanks all...

It works......