topic Re: label color change in QlikView

label color change

ssriramin19 — Thu, 27 Aug 2015 06:38:00 GMT

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

Re: label color change

qlikmsg4u — Thu, 27 Aug 2015 06:44:20 GMT

Expand Dimension > Text color

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

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

Re: label color change

gautik92 — Thu, 27 Aug 2015 06:44:49 GMT

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

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

Re: label color change

tresB — Thu, 27 Aug 2015 06:46:05 GMT

Text Color expression, like:

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

Re: label color change

krishna20 — Thu, 27 Aug 2015 06:47:51 GMT

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.

Re: label color change

prajapatiamar38 — Thu, 27 Aug 2015 06:48:07 GMT

GO to dimension click plus(+) sign

select text Color write expression:

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

Re: label color change

ali_hijazi — Thu, 27 Aug 2015 06:48:39 GMT

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

Re: label color change

ssriramin19 — Thu, 27 Aug 2015 06:52:17 GMT

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

Re: label color change

qlikmsg4u — Thu, 27 Aug 2015 06:56:42 GMT

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.

Re: label color change

ssriramin19 — Thu, 27 Aug 2015 06:56:46 GMT

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.

Re: label color change

tresB — Thu, 27 Aug 2015 06:58:01 GMT

Try to share a sample qvw.

Re: label color change

Thu, 27 Aug 2015 07:02:00 GMT

Looks like you need to color the expression and not the dimension. In that case you can go to to expression and then hit '+' symbol and make a condition in the 'Backgroud Color'.

If(MixMatch('Your Expression', 'Stock Item', 'No Stock Item','DP Next Year'), ARGB(200,200,200,200))

Re: label color change

krishna20 — Thu, 27 Aug 2015 07:04:01 GMT

Hi,

Have u tried custom cell format???

Re: label color change

ssriramin19 — Thu, 27 Aug 2015 07:05:03 GMT

I need to change the color of the label mentioned above for the three expressions to red color.Its only the label in the expression needs to be changed.

Re: label color change

ssriramin19 — Thu, 27 Aug 2015 07:06:19 GMT

Custom cell format changes color for all the expression label not to any particular mentioned expression label.

Re: label color change

mohammadkhatimi — Thu, 27 Aug 2015 07:10:11 GMT

In Text Color expression of MRE(Calculation D&E):

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

Hope this will helps You..!!

Regards,

Mohammad

Re: label color change

ssriramin19 — Thu, 27 Aug 2015 07:12:35 GMT

its not the dimension its the expression label which needs to be made to different color

Re: label color change

tresB — Thu, 27 Aug 2015 07:13:36 GMT

AFAIK, unfortunately that can't be done for specific labels.

Re: label color change

ssriramin19 — Thu, 27 Aug 2015 07:16:53 GMT

Then how that should be achieved. Any other suggestion or work around to achieve this. Shall I inform the user that it is not possible to make color changes to label as desired?

Re: label color change

mohammadkhatimi — Thu, 27 Aug 2015 07:22:23 GMT

Above expreesion u have to write in expression MRE(Calculation D&E):

Click on + and in that text expression..

Regards,

Mohammad