Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.....!
Expand the expression and click on text color and give expression
Check the file
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()))
Expand the expression and click on text color and give expression
Check the file
Ya It works for Me.
Thanks Sivaraj & Johannes for your quick Response...
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
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
Right click on column you want to change --> custom format cell --> Text Setting --> Change to bold
Thanks all...
It works......