Bitmetric Friday Qlik Test Prep – Week 5 – Set Analysis – Solution

Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Business Analyst certification practice question:

No alt text provided for this image

There was a little catch to this question, which fooled exactly no one 😉

read more »

Friday Qlik Test Prep – Week 4 – Time series visualization – Solution

Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Business Analyst certification practice question:

The answers you gave to this question were quite varied, with each answer getting at least one mention. While in real life there is often room for nuance, in the context of Qlik certifications there is typically only one answer:

read more »

PinIt 2.1 sneak preview – improved favorites

With PinIt anyone can create self-service mashups, letting you combine charts from multiple Qlik Sense apps into overviews that are relevant to you. No code, no hassle.

Next week we’ll be releasing version 2.1 of PinIt. One of the improved features that I quite like are favorites. These let you instantly switch between your favorite apps, sheets and objects. Watch a quick demonstration in the video below.

PinIt is free to use, so if you want to try it, you can download it from our website here:

Get PinIt for Qlik Sense


Another feature I quite like is the Shared Calendar. This let’s you use a common calendar across all apps on your pinboard. The video below gives you an impression of how it works:

If you’ve had a chance to try PinIt then I’d be very interested in hearing your feedback!

Friday Qlik Test Prep – Week 3 – Circular references and Synthetic Keys

Qlik certification test question 3 - circular references and synthetic keys

Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question:

read more »

Free eBook: Get your Data Literacy lights on in 2022!

Data is the new language of business. And company-wide fluency is vital to ensure everybody is making data-driven decisions. Learn more about the benefits of data literacy in this eBook: Data literacy – How to make data every employee’s friend, co-authored by our colleague Angelika Klidas (Bitmetric) and Vizlib (providing value-added products for Qlik Sense).


You can empower everyone at your organization to reach their maximum potential. With the skills to read, write, analyze and think with data, every employee can uncover the right insights that boost productivity and generate more business value!

read more »

Friday Qlik Test Prep – Week 2 – Section Access


Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question:

read more »

Friday Qlik Test Prep – Week 1 – Optimized Load

For the new year, we’re doing something new at Bitmetric. Each Friday, on our LinkedIn Company Page, we’ll share a test question that is representative of what you’ll find on the Qlik Business Analyst, Data Architect or System Administrator certification exams. Including the strange or vague wording that’s sometimes found in these exams 😉

We’ll follow up each Monday with the correct answer, as well as some additional explanation and insights. We hope this will help many of you prepare for your Qlik certifications, or at the very least provide a bit of fun and discussion.

read more »

Bitmetric Qlik Sense Coding Conventions – free download

At Bitmetric, we don’t believe in universal ‘best practices’. Which approach, standard or method works best should always be evaluated in the context of the environment. That being said, there are certainly starting points that can serve as ‘good ideas’.

Today we offer you one such starting point, the Bitmetric Coding Conventions for Qlik Sense.

Read on and find out how you can get your free copy of this document.

read more »

Webinar PinIt june 11th

Data Literacy adoption, boosting self-service, cost saving and rapid prototyping.

You know how to grind hard and get things done. You don’t mind putting in some extra effort if needed. Your passion is not only working with data, but also helping others understand it and answering their questions. You enjoy diving deep into data and analyzing it, to help your client/business to the next level.

The struggle of data adaption

You just released a new dashboard while you are already maintaining several other dashboards. All of these dashboards have different users. For instance, the operations dashboard you developed was meant for operations, but now management is also using this dashboard. They are not interested in all the visualizations and tables that are included in the sheets/dashboard. They just want to see (their) clear KPIs, You keep getting requests to build new sheets, not only for the strategic dashboard but also all the other dashboards you maintain. They all just want to have a sheet rearranged or a sheet with just KPIs etc., so that the data fits their personal workflow. The end result is that you either end up with dozens of sheets or, if you’re strict, an app that caters to only the lowest common denominator. In both cases you will find that usage and adoption will soon stagnate.

PinIt as solution

What if there was a simple solution for these problems? Well this is what fired our spark to build PinIt, we created it, launched it, and now you can use it. With PinIt everyone can create their own pinboards based on existing visualizations (including master visualizations) that are already in all the  different dashboards. With just a few clicks you can get every chart you would like, can read and interpreted combined into one single pinboard (or if you like multiple pinboards), the cool thing is you are not limited to visualizations from one dashboard, but you can use all visualizations from your dashboards. So instead of building new dashboards/sheets for every separate user, they can build their own pinboard(s). With PinIt you can also share created pinboards. Check out this video to see how easy you can create a pinboard

Going back to the first example, where you build a dashboard for operations, but management also want to use the same visualizations but not all the charts in it. Simply just create a new pinboard with only the KPIs and you can release it to the management team. The neat thing about this is if you need to update something in the pinboard you can just edit it, and without a new release, or transfer from environment everyone with whom you shared the pinboard can instantly see it.

What’s in it for you?

Of course we didn’t forget about you, the developer. We all know those requests where the business has some vague idea of a dashboard and asks you to build it based on already existing dashboards. Normally this could take anywhere from a day to a month. With PinIt this can be done in a matter of minutes/hours and instantly released to your target audience, so they can test it for a few days/weeks and if needed it can be developed into a new dashboard, or the pinboard is already sufficient.

Security

Now you might be worrying about security. Well we solved this problem the easy way, your environment your rules! Is a user able to see the data in Qlik Sense? Then they can also see it in PinIt, to say it in other words we use the Qlik Sense security rules.

Join us

Does this spark your interest? Download the trial at https://www.getpinit.com or join us at our webinar at the 11th of June. You can sign up for the webinar here https://www.getpinit.com/webinar/join-the-pinit-webinar-on-june-11/

Season’s greetings!

Season’s greetings from your friends at Bitmetric and the QlikFix! It’s been more than 6 years since I added an entry into the visual FX category, but recent technological advances at Qlik have finally made it possible to create animated scatter charts in Qlik Sense as well. So without further ado, here’s our Qlik Sense animated greeting to you. Wishing you and yours happy holidays and all the best for 2021!

Want to see how it works? Download the QVF file by clicking here.
This QVF uses our 2018 Christmas Theme, which you can download here.

Music credits: Wham – Last Christmas (8-bit) by Mongrelvids