Discussion Board for collaboration on QlikView Scripting.
Please find the screen sheet
lots received and lar % and scar rate have the expressions .
I need the label in bold
Right click on the label, then hit "Custom Format Cell".
If "Custom Format Cell" is not available, make sure Styling Mode is set to Advanced in Document Properties:
Use Custom Format Cell and tick the bold tick box
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.
Setting -> User Preferences -> Font "To choose the font for entire dashboard"
Thanks in Advance
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
Try this macro, it will change font, bold, italic and size but not color
set sp = ActiveDocument.ActiveSheet.GetProperties
set sfont = sp.SheetFont
sfont.FontName = "Calibri"
sfont.Bold = True
sfont.Italic = false
sfont.Underline = false
sfont.PointSize1000 = 11000
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
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,