Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

How to label the Expression in bold

Please find the screen sheet

label name.PNG

lots received and lar % and scar rate have the expressions .

I need the label in bold

Tags (1)
9 Replies

Re: How to label the Expression in bold

Right click on the label, then hit "Custom Format Cell".

Re: How to label the Expression in bold

If "Custom Format Cell" is not available, make sure Styling Mode is set to Advanced in Document Properties:

rustyfishbones
Honored Contributor II

Re: How to label the Expression in bold

Use Custom Format Cell and tick the bold tick box

2013-11-19_1956.png

2013-11-19_1956_001.png

Not applicable

Re: How to label the Expression in bold

Hi Alan,

Thanks for the reply, if I have multiple tables, and I need to change(font, bold, color) all the fields.

Its taking a lot of time to change, by selecting each column. Is there any one time setting for this.

Eg:-

Setting -> User Preferences -> Font     "To choose the font for entire dashboard"

Thanks in Advance

Pavan Kumar.

rustyfishbones
Honored Contributor II

Re: How to label the Expression in bold

Hi Pavan,

Yes, but you need to do this before you create and objects, charts, button etc....

But if you have created all of the objects already you probably need a macro to change previously created charts, objects, button fonts

There is a macro you can try to change all font to bold etc...

let me try find it

rustyfishbones
Honored Contributor II

Re: How to label the Expression in bold

Hi Pavan,

Try this macro, it will change font, bold, italic and size but not color

SUB Font()

set sp = ActiveDocument.ActiveSheet.GetProperties

set sfont = sp.SheetFont

sfont.FontName = "Calibri"

sfont.Bold = True

sfont.Italic = false

sfont.Underline = false

sfont.PointSize1000 = 11000

ActiveDocument.ActiveSheet.SetFont sfont

END SUB

rustyfishbones
Honored Contributor II

Re: How to label the Expression in bold

Pavan,

for the color, it's better to create variables for colors, so if you need to change the whole look of the application you could just change the variable once

I made a video on youtube about it

Not applicable

Re: How to label the Expression in bold

thanks alan

Not applicable

Re: How to label the Expression in bold

Amazing Alan, I'm a big fan of you.

Thank you very much.

Small request Alan, could you please share any link or documents to learn Macro's from the basics.

I'm very poor in Macro's.

Please help me out of this.

Thanks & Regards,

Pavan.

Community Browser