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
ivan_will
Partner - Creator II
Partner - Creator II

Hi Piers,

unfortunately I haven't yet ... seems it is a bug!

0 Likes
1,039 Views
tiago_hubner
Partner - Contributor III
Partner - Contributor III

Great!

0 Likes
1,039 Views
arulsettu
Master III
Master III

Hi Arturo Muñoz

i followed everything as you mentioned. but its not changing the font in client machine

code is like below

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

  //Load a CSS style sheet

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

  });

can you please take a look

Thanks

0 Likes
1,039 Views
ArturoMuñoz
Employee
Employee

Looks good to me, please double check that line gets loaded when your app is open webview or in browser. Please check the previous comments for tips, you will find some other having issues.

0 Likes
1,039 Views
alistairross
Partner - Contributor III
Partner - Contributor III

Hi,

What should I put in the LoadCSS if I am not using google fonts? I have my own font which I have installed on my desktop and on the QVS, but don't have a css file. Can you help?!

Thanks

Alistair

0 Likes
1,017 Views
ArturoMuñoz
Employee
Employee

Hey Alistair,


You should be able to use your own font, you just need to adjust the extension a little bit to use the font hosted in your own server, instead of ("http://fonts.googleapis.com/css?family=Abel"); you should define your font-face as described here: CSS3 Web Fonts


Something like

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

           //Load a CSS style sheet

     Qva.LoadCSS("@font-face {font-family: myFont; src: url(myFont.woff);}");

           });

0 Likes
1,017 Views
obruski10
Contributor II
Contributor II

Hi Arturo,

is it also possible to point to a local CSS instead defining the font-face inside the LoadCSS function??

Thanks in advance.

0 Likes
1,017 Views
owais_sarwar
Contributor II
Contributor II

Hi @amz

There is an issue i am facing to regarding the qlikview compatibility with my custom font i.e. Bebas Nueue Bold.

I downloaded the attached file "Customfonts.qar" as you have uploaded. Changed the file type in to ZIP. There are two files Script and definition. I opened the difiniton via Notepad and mad changes as you have elaborated.

<?xml version="1.0" encoding="utf-8"?>

<ExtensionObject Label="customfonts" Path="customfonts" Description="Loads customfonts " Type="Bebas Nueue Bold">

</ExtensionObject>

I am then trying to rename the Zip file in to "customfonts.qar" format again. It is not changing it file type to qar instead its just showing the same ZIP file.

Your cooperation would be highly appreciated.

0 Likes
1,017 Views
Anonymous
Not applicable

Hello! 

How can I make a reference to a font file that is not disponible at internet. A local file at my qlikview server for example.

Thanks!

0 Likes
1,017 Views
skyCoin
Partner - Contributor III
Partner - Contributor III

Anyone having issues with this extension on version 12.4 SR 1? We recently upgraded from 12 and are experiencing a strange issue.

The correct google font gets loaded, but there is spacing above and below that gets shortened. If the fontsize is small then in some tables the text gets cut off from the bottom due to the cells having too short of a height.

However, upon refreshing the browser page, the font returns back to normal and the spacing and cell heights are back to the way it was. Any ideas? I would rather not have our clients refreshing the qlikview app. 

0 Likes
860 Views