How to change back ground Colour of Expression Label

[#1]

Dear All,

for an expression if i am setting background colour then its only applying for resulted value  but i want for the same for Label

Getting Format :

Plant	Date	Sourcing	Import	Net
abc	01-12-2016		0.00	4,82,003.00
abc	02-12-2016		0.00	4,39,639.00
abc	03-12-2016		0.00	4,37,573.00
abc	04-12-2016		0.00	4,06,930.00

Expected Format :

Plant	Date	Sourcing	Import	Net
DPM	01-12-2016		0.00	4,82,003.00
DPM	02-12-2016		0.00	4,39,639.00
DPM	03-12-2016		0.00	4,37,573.00
DPM	04-12-2016		0.00	4,06,930.00

[MK_QSL]

If it is pivot table.. follow below link..

Background color of Pivot Table Labels

[MK_QSL]

For straight table you need to use ValueList as per below link.

This might affect performance of your table (depends on data)

Changing color for individual column header in a straight table

[avinashelite]

Try like this

1.Click on the Design Grid option from the Design tool bar

2. Right click on the cell where you want to add the background color

3.on Right click you will see an option Custom format cell

4. Here you will get the option to add background color for required cells

Hope this helps you

[#5]

if i do this it will apply for all the expression labels. but i need it for selected Expression labels only

[#6]

Yes it's pivot table and in this article its arrived by using maro.

is it any solution with out using macro.

Thanks....

[MK_QSL]

You can use this for Straight/Pivot table both.

Changing color for individual column header in a straight table

[petter]

If you don't need to use the total row it can be employed as a column header row. You have to turn off the regular column headers and turn on the total row. Then you have to test in the expressions whether the expression is evaluating for the total row which looks like this:

    If( IsNull( RowNo() ) , <expressions for total row> , <expression for normal rows> )

Furthermore you need to add helper columns as expression that mirror the dimensions you have and then hide the dimension columns....

This is convoluted but it works. I have attached a simple example QlikView appliication:

[saimahasan]

Use Custom Format Cells option

[pipuindia99]

Use RGB() function in expression background option.