topic Re: How Do You Make Multiple Label Colours in Expressions in QlikView

How Do You Make Multiple Label Colours in Expressions

Tue, 17 Jul 2012 14:50:27 GMT

Hello -

I have a straight table with multiple expressions. Each expression is colour coded using assigned variables to visually group and easily distinguish. I know how to colour the expressions by clicking on the + sign and selecting background colour and assigning an RGB to that expression and even assigning a RGB to the Text BUT it does not colour the Labels which are essenitally the row headings to match the expression.

Is this possible within a straight table?

Thank you in advance!

Re: How Do You Make Multiple Label Colours in Expressions

cesaraccardi — Tue, 17 Jul 2012 17:00:44 GMT

Hi,

You can achieve this by enabling the Design Grid (View / Design Grid) and right clicking it the table, select "Custom Format Cell". At this dialog you can edit each column/cell individualy.

Hope this helps.

Regards,
Cesar

Re: How Do You Make Multiple Label Colours in Expressions

Tue, 17 Jul 2012 18:43:31 GMT

Thank you Ceasar but unfortunately that didn't work.

Perhaps further explaining the format of my Straight Table might help or explain why it didn't work. The table is in Horizontal mode and has only one dimension of Month-Year so we can see sales/forecasts etc across time. I use expressions to make various calculations of sales/forecasts and colour the rows but need the Labels for those rows(expressions) to makch the colour of the rows ... currently the rows are coloured but their labels remain black text on white background.

Thank you in advance,

Däv