topic Re: Conditional Font Family and Font Size in QlikView

Conditional Font Family and Font Size

sohailansari201 — Tue, 09 Sep 2014 15:58:40 GMT

When we click the plus sign next to a dimension or expression, there is an option for "Text Format". I remember it very well that you can change the Font size by providing the actual font size i.e. 8,9,10,11,12....etc. Also I remember you can define the font family as well for e.g. Arial, Times New Roman etc. all within the Edit Script box when you double click the "Text Format" icon. But I fail to remember the syntax and unable to find any help on the community.

I am attaching the conceptual screenshot.

Does anyone remember how to make this change?

Thank you,

Re: Conditional Font Family and Font Size

MK_QSL — Tue, 09 Sep 2014 16:05:37 GMT

Go to Settings

Document Properties

FONT

Re: Conditional Font Family and Font Size

JonnyPoole — Tue, 09 Sep 2014 16:15:28 GMT

You may have seen this but there isn't too much you can do on the text format. Bascially bold, underline, italic: '<B>' , '<U>' or '<I>'

But also consider right clicking on your table and selecting 'custom format cell' . You can increase the font size there too.

Re: Conditional Font Family and Font Size

sohailansari201 — Tue, 09 Sep 2014 17:28:22 GMT

Thanks Jonathan. The 'custom format cell' provides a very limited options with font sizes....Also, it doesn't let you change the font family. I have done this a very long time ago but couldn't remember it now.

Thanks for your help.

Re: Conditional Font Family and Font Size

sohailansari201 — Tue, 09 Sep 2014 17:30:21 GMT

But Manish that would apply the font and color settings to the entire document? My question is about a single dimension or expression and changing the font size and family via script.

Thank you

Re: Conditional Font Family and Font Size

JonnyPoole — Tue, 09 Sep 2014 18:57:38 GMT

I agree ! conditional font control within a chart can be a little tricky. I like the additional reporting tool NPRINTING for this kind of thing especially for tabular reporting. cell by cell formatting is possible.

I will be watching your post in case there is a feature i'm not aware of.