topic Re: Formating Labels in QlikView

Formating Labels

mariozubieta — Wed, 09 Aug 2017 21:29:41 GMT

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:

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

Re: Formating Labels

Anil_Babu_Samineni — Thu, 10 Aug 2017 02:44:56 GMT

WE can work if you provide more information and sample application

Re: Formating Labels

neha_shirsath — Thu, 10 Aug 2017 05:11:24 GMT

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

Re: Formating Labels

balar025 — Thu, 10 Aug 2017 06:32:52 GMT

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

Re: Formating Labels

ecolomer — Thu, 10 Aug 2017 06:50:07 GMT

See this:

Re: FORMATO DE TEXTO

Re: Formating Labels

mariozubieta — Thu, 10 Aug 2017 18:14:24 GMT

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.

Re: Formating Labels

mariozubieta — Thu, 10 Aug 2017 18:15:15 GMT

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.

Re: Formating Labels

neha_shirsath — Thu, 10 Aug 2017 18:46:53 GMT

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

Re: Formating Labels

mariozubieta — Mon, 14 Aug 2017 21:30:42 GMT

Here is an example.

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

thanks

Re: Formating Labels

mariozubieta — Mon, 14 Aug 2017 21:31:05 GMT

here an example

Re: Formating Labels

Anil_Babu_Samineni — Tue, 15 Aug 2017 01:01:03 GMT

May be work around?