Author Archives: Frédérique Verhagen

Frédérique Verhagen

Frédérique Verhagen

Hi! I am Frédérique, I graduated in Business Mathematics from the Hague University of Applied Sciences and am working as a Junior Business Intelligence Consultant at Bitmetric since February 2015. Via my blog posts, I will share interesting QlikView/Qlik Sense features and applications that I come across. My main subject areas will be data visualization and applied mathematics.

Handling multiple languages and translations

Handling multiple languages and translations in QlikViewRecently I made a QlikView application with multiple languages. I came across a blog post by Charles Bannon: “Handling multiple languages”. Charles describes two scenarios for the use of multiple languages. The first scenario, “translate labels and textboxes within the application and not the actual data”, solved my problem. Charles uses a translation table with an index. He uses set analysis to reference the index number and the language. The expression used is:

=Only({<Index={5}>} [$(=vDataLanguage)])

A good solution, but not very user-friendly. Do you know which translation belongs to index 5?

In this blog post I will rewrite the expression to a more user-friendly and readable formula, and will also explore some other ways of dealing with translations in QlikView.

read more »

Geographical analysis with QlikMaps

QlikMaps

There are multiple mapping extensions available for geographical visualization and analysis in QlikView and Qlik Sense. Examples of commercial offerings are GeoQlik, NPGeoMap, Idevio and QlikMaps. Bitmetric (the people behind this blog 😉 ) is a QlikMaps partner, so I have been working a lot with QlikMaps recently. I have found it very powerful yet easy to work with.

QlikMaps demo

Today I want to share with you a small demo that I built. This demo shows demographic information about London mixed with a few of my holiday snapshots. The demo shows most of the common features of QlikMaps.

Want to try QlikMaps?

QlikMaps is available for both QlikView and Qlik Sense. Want to get a free trial and try it out with your own data? Then send us a request using the form below and we’ll get you hooked up!

Your Name (required)

Company Name (required)

Your Email (required)

Please repeat the following text
captcha

 

Target lines on a bar chart using error bars

During my internship at Bitmetric one of my project goals was to build a QlikView application to benchmark logistical companies. I needed to visually compare the results of one organization with the average results of all organizations. My first try was using a combo chart with symbols, but I wasn’t happy with how that looked:

Error bars ComboChart

The dot seems to reflect an interval instead of a value. What I really wanted was to make is a chart that uses a straight line for the benchmark:

Individual target lines on a QlikView bar chartIn this blog I will show you how you can make such a chart.

read more »