Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
mariozubieta
New Contributor III

Formating Labels

Hello,

I have a table and I'm trying to format the Labels to look the same as the expressions.

Here is an example of how my Table Looks:

tableexmple.jpg

I would like for the Labels (TOTAL TARGET, Total Forecast, etc) to have the same color background as their row.

This would make TOTAL TARGET, Total Forecast, Forecast % to Target a light green, then a blank row, then yellow and so on.

Can this be done?

thanks

10 Replies

Re: Formating Labels

WE can work if you provide more information and sample application

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
neha_shirsath
Valued Contributor

Re: Formating Labels

yes this is possible, you can do this by Custom format cell. right click on your chart and you will see this option.

balar025
Contributor III

Re: Formating Labels

Can you please share your application?

You have to use conditional background color of your dimension fields.

Like If (Dimension='Total Target',Green()......so on) or Pick match color will work or in script you can define group  for colors. so that same you can use it in expression also.

Custom Format will not work  because it gives color to entire dimension rather than giving to one single cell of dimension.

Regards,

Ravi

ecolomer
Honored Contributor II

Re: Formating Labels

mariozubieta
New Contributor III

Re: Formating Labels

The problem is that this are the labels from the formulas. My dymension are placed on top and the formulas labels are the ones im trying to edit.

mariozubieta
New Contributor III

Re: Formating Labels

The problem is that this are the labels from the formulas. My dymension are placed on top and the formulas labels are the ones im trying to edit.

neha_shirsath
Valued Contributor

Re: Formating Labels

Can you please share the sample file of your data..so that your requirement will be more clear to understand.

mariozubieta
New Contributor III

Re: Formating Labels

Here is an example.

I need the Formula Labels color changed to the same as inside the expression.

thanks

mariozubieta
New Contributor III

Re: Formating Labels

here an example