topic Re: label color change in QlikView

label color change

ssriramin19 — Tue, 01 Dec 2015 07:27:49 GMT

Below is my requirement

The label (OP/MRE Ratio) background color needs to be changed to white color .

I have written the expression for back ground color .The expression for color which I have given is according to the requirement and it is properly met.

But the only thing is label back ground needs to be in white color but it not being displayed.

Can anyone please help me how to change the label back ground color ?

Thanks

Sriram

Re: label color change

arulsettu — Tue, 01 Dec 2015 07:31:49 GMT

remove the color expression from background

Re: label color change

ssriramin19 — Tue, 01 Dec 2015 07:35:44 GMT

If I remove the color expression I may not be able to meet the requirement .The numbers in percentage needs to be given in color.

so only for that back ground color expression is being given.

But along with that label back ground color also got changed from white to colored expression

Re: label color change

arulsettu — Tue, 01 Dec 2015 07:37:11 GMT

post your sample app

Re: label color change

tamilarasu — Tue, 01 Dec 2015 07:39:11 GMT

Hi SriRam,

Right click on the chart, you will see custom format cell option. Change the background color to white for the specific dimension,

Re: label color change

Anonymous — Tue, 01 Dec 2015 07:45:13 GMT

First Select Design Grid form menu near to Format Painter.

Then

Right Click on (OP/MRE Ratio) cells -> Custom Color -> Then BackGrould Color as suggested by Tamil.

See the attachment

Re: label color change

dhasharadh — Tue, 01 Dec 2015 07:48:47 GMT

Hi Sriram,

if it is a dimension you can change as below , click on + symbol and then do as below

hope this will help u

Regards

Re: label color change

engishfaque — Tue, 01 Dec 2015 07:51:18 GMT

Dear Sriram,

Step 1:

Menu "Settings" > User Preferences > Tab "Design" > check to checked box "Always Show Design Menu Items" > Apply > OK.

Step 2:

Right click on your table Cell (such as MRE Ratio) > Custom Format Cell > change "Background Color".

Kind regards,

Ishfaque Ahmed

Re: label color change

kumarkp412 — Tue, 01 Dec 2015 08:02:18 GMT

Hi Sriram,

As of my understand, you need to change the background color of the dimension,

For that, In the dimension tab - expand the label - you will see the background color option -make the RGB color you need and with the expression where dimension = op/mr ratio.

Thanks

Kumar