label color change

[ssriramin19]

Please help me in how to change the color of the label as mentioned below.

This is not for all the dimension labels only for the selected.

!

As mentioned above only the highlighted label names needs to be colored.

How this needs to be achieved?

Thanks

Sriram

[qlikmsg4u]

Expand Dimension > Text color

=If(YourDimension='Stock Item' or YourDimension = 'Non Stock Item' or YourDimension = 'DP Next Year',Red(),Green())

or

=If(Match(YourDimension,'Stock Item','Non Stock Item', 'DP Next Year'),Red(),Green())

[gautik92]

in dimesion tab click on + in dimension and in text color add this expr

=if(Fieldname='Stock Item',RGB(255,0,255))

[tresesco]

Text Color expression, like:

If(Match(DimensionName, 'Stock Item', 'No Stock Item','DP Next Year'), LightRed())

[krishna20]

Hi,

Activate Grid Selection in sheet. Then right click on label where you need to change color,then select custom format cell. You can achieve by this.

[prajapatiamar38]

Hi

GO to dimension click plus(+) sign

select text Color write expression:

If(fieldname='Stock Item',Red())....etc

[ali_hijazi]

in Dimensions tab choose back color as shown above and put your condition

it will be something like this:

if (wildmatch([Column_name],'stock item','non stock item','dp next year')>0, rgb(255,0,0))

[ssriramin19]

The above three fields refers to expression label. many rows and columns has been moved to get the above mentioned structure.

for the mentioned three expressions various formulas are written to compute those three expression.

How this needs to be achieved?

since when I click the '+' sign near the expression and selecting text color  "Stock Item" all the values corresponding to stock item are turning to red color .

But I want the label only to be made to red for the above mentioned three expressions?

Please guide me on this

Thanks

Sriram

[qlikmsg4u]

You can colour a column with the "background colour" option in expressions or dimensions tab. But I don't think you can just colour a column header.

[ssriramin19]

it is not in the dimension ,. It is the expression .Stock Item is the label for the expression.I need  to change only the label for the expression.