Skip to main content
ArturoMuñoz
Employee
Employee

One of the topics we always cover in our data visualization training courses is the font family selection within your app. With the increasing number of devices and platforms accessing to your QlikView apps, details such as font size and type have become in a very important piece of the app success.

As a rule of thumb our recommendation is to keep your app as simple as possible, meaning using Arial or any other font that work well across devices. It’s important to note that fonts such as Tahoma or MS Calibri will force those devices that don’t come with those fonts installed, to pick an alternative font based on the font family. That may cause your app to be unreadable and/or blurry in some situations.

But let’s say you really need to use a non-standard typeface to customize one of your apps. Is that doable with QlikView?

The answer is yes, you can customize QlikView apps based on your needs and use an external font from Google or any other font servers.

To do so you will need to install and customize a document extension – you can download it at the bottom of this post - and then follow the next steps:

1. Search or browse font families at google.com/fonts you want to use in your QV app For this example, I’m going to pick the Abel font for my project, one of the many open source fonts hosted at google.com/fonts. You could choose a different provider or just host the font file on your own server.

google.png

2. Once you have chosen your font, grab a copy of the font file and install it on the computer where you are developing your app and in the machine(s) that host the QlikView Server(s). This is especially important: you must install the font on the QV server host machine if you want your charts to be rendered using the selected font.

3. Open your QlikView app with QlikView Desktop and modify the font as usual:

step3.png

step3-2.png

4. Once we are done applying your font across all the app objects it’s the time to review the document extension.

5. Download the extension attached at the bottom of this post, rename the file from ExtensionName.qar to ExtensionName.zip and unzip it.

A document extension will include at least 2 files, Definition.XML and Script.js.

The JS file will look like the example below where Abel is the font I chosen.

Qva.AddDocumentExtension('customfonts', function(){

           //Load a CSS style sheet

     Qva.LoadCSS("http://fonts.googleapis.com/css?family=Abel");

           });

Edit Script.js file and modify it to include your chosen font name as in the example above.

Compress the 2 files into a zip file and then rename it as ExtensionName.qar

6. Install the document extension in your environment.

    More info on how to do it here: http://www.qlikblog.at/1597/qliktip-40-installingdeploying-qlikview-extensions/

7. Go back to QlikView and activate the document extension in the app:

step7.png

From now on when the page loads, QlikView will include the extension and the font will be loaded across devices.

8. Publish your app to the server and enjoy your custom fonts in any device.

As a general recommendation you should stick to one of the 'standard' fonts such as Arial but in the case of you trying something new, following the described 8 steps you should be able to deploy a QV app to a server with a non-standard font on it.

PROS: Wide range of font styles to choose from, easy app customization, web standard fonts, works well across any device.

CONS: Web only, small impact on page load time.

Enjoy Qliking!

Arturo

62 Comments
ArturoMuñoz
Employee
Employee

Glad to hear that!

0 Likes
753 Views
daniel_kusiak
Creator II
Creator II

Great tutorial. Thanks.

0 Likes
753 Views
ivan_will
Partner - Creator II
Partner - Creator II

Guys, I still can not have the extension running on the server.

I want to use Exo 2 font from google.

Did the steps from the theme 1:1, allow extensions is marked, added @import url(http://fonts.googleapis.com/css?family=Exo+2);

copied the folder Extensions from C:\Users\user\AppData\Local\QlikTech\QlikView to the C:\ProgramData\QlikTech\QlikViewServer

and still the same ...

Please advise me what to do?

Thank you

0 Likes
789 Views
ArturoMuñoz
Employee
Employee

Hey Ivan,

Please make sure you place the extension in the right folder: QlikTip #40: Installing/Deploying QlikView Extensions

0 Likes
789 Views
ivan_will
Partner - Creator II
Partner - Creator II

Hi Arturo,

Yes, I have copied it to the right folder.

this is what I have in the script,js:

Qva.AddDocumentExtension('customfonts', function(){

  //Load a CSS style sheet

  Qva.LoadCSS("http://fonts.googleapis.com/css?family=Exo+2");

  });

Here I tried it with Exo 2, Exo%202 , .... the same ...

Tried on a different server with Abel font and it works, when try with Exo 2 it doesn't ...

Probably Exo 2 is not supported or ... ?

0 Likes
789 Views
ArturoMuñoz
Employee
Employee

If I remember well it was a little bit tricky when the font name have spaces. Anyway try to debug the page using your browser developer tools and check that the font is actually being loaded

0 Likes
789 Views
ivan_will
Partner - Creator II
Partner - Creator II

Hi, seems it is not loaded ... can't see it anywhere in the script.

...

Seems the solution is partly possible.

Anyone else experiencing the same problem?

0 Likes
789 Views
ArturoMuñoz
Employee
Employee

Is this working on your desktop and stop working when in Server? Are you using any other server extensions? are they working properly? Just to make it clear, this is a document extension so it should be placed under Document folder.

C:\Users\[user]\AppData\Local\QlikTech\QlikView\Extensions\Document (Win7)

If other document extensions are working properly then I would focus on understanding why this particular one doesn't load properly by debugging the web site. As a temporary fix you could try Kris Vliegen's workaround:

I've set the following in the begin of the default.css in C:\Program Files\QlikView\Server\QlikViewClients\QlikViewAjax\htc

@import url(http://fonts.googleapis.com/css?family=Open+Sans);

0 Likes
789 Views
ivan_will
Partner - Creator II
Partner - Creator II

Hi Arturo, I have already tested all possible combinations ... Don't know what would be the reason. Have you ever you managed to have such a font like Exo 2 (with space) working properly with the extension?


Also what I see is that actually in IE browser using ajax the fonts are working well but in Chrome they are not rendered properly!? Ideas? Bug? ...

0 Likes
817 Views
Not applicable

HI Ivan, I have this problem too. have you had any luck resolving this?

0 Likes
817 Views