topic Re: Text Color Change in Table in QlikView

Text Color Change in Table

Tue, 20 Nov 2012 10:01:16 GMT

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

Re: Text Color Change in Table

Anonymous — Tue, 20 Nov 2012 10:04:06 GMT

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()))

Re: Text Color Change in Table

sivarajs — Tue, 20 Nov 2012 10:04:20 GMT

Expand the expression and click on text color and give expression

Check the file

Re: Text Color Change in Table

Tue, 20 Nov 2012 10:26:36 GMT

Ya It works for Me.

Thanks Sivaraj & Johannes for your quick Response...

Re: Text Color Change in Table

Tue, 20 Nov 2012 10:50:41 GMT

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

Re: Text Color Change in Table

Tue, 20 Nov 2012 11:01:06 GMT

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.

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

Re: Text Color Change in Table

sivarajs — Tue, 20 Nov 2012 11:05:46 GMT

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

Re: Text Color Change in Table

Tue, 20 Nov 2012 11:07:47 GMT

Thanks all...

It works......