topic Re: How to label the Expression in bold in QlikView

How to label the Expression in bold

Tue, 19 Nov 2013 19:29:34 GMT

Please find the screen sheet

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

I need the label in bold

Re: How to label the Expression in bold

Nicole-Smith — Tue, 19 Nov 2013 20:03:45 GMT

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

Re: How to label the Expression in bold

Nicole-Smith — Tue, 19 Nov 2013 20:04:34 GMT

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

Re: How to label the Expression in bold

rustyfishbones — Tue, 19 Nov 2013 20:10:37 GMT

Use Custom Format Cell and tick the bold tick box

Re: How to label the Expression in bold

Wed, 20 Nov 2013 10:08:51 GMT

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.

Re: How to label the Expression in bold

rustyfishbones — Wed, 20 Nov 2013 10:26:58 GMT

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

Re: How to label the Expression in bold

rustyfishbones — Wed, 20 Nov 2013 10:29:18 GMT

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

Re: How to label the Expression in bold

rustyfishbones — Wed, 20 Nov 2013 10:33:18 GMT

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

Re: How to label the Expression in bold

Wed, 20 Nov 2013 18:48:58 GMT

thanks alan

Re: How to label the Expression in bold

Thu, 21 Nov 2013 07:30:15 GMT

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.