Category Archives: Tools

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/

Implementing section access based on Qlik Sense user table.

Welcome to my third Blog post, which will be a basic tutorial of how to setup section access for your Qlik Sense application, based on the Qlik Sense user table. This approach, created together with my colleague Martijn Olivier, is straight forward to implement in various occasions. My aim is not to over complicate it with all the extra possibilities that are possible. Also bear in mind that it should not substitute application level access based on security rules. This method describes how to implement section access within an application, based on a custom property assigned to a group of users.

read more »

Tutorial Tuesday: Implementing version control for Qlik Sense with Git, GitHub and Visual Studio Code

Welcome to my second Blog post, which will be a basic tutorial of how to setup a lightweight version control for Qlik Sense script. This approach is straight forward to implement in various occasions. My aim is not to over complicate version control by offering this as a nice beginners guide on version control and workflow.

This tutorial will be part of a series of Tutorial Tuesdays that will lead to a lightweight, straight forward and easy to implement framework within Qlik Sense. In the series of tutorials hereafter will we cover topics as version control with script changes, different localization settings, loading centralized variables, creating master items on variables and eventually getting a simple dashboard up and running based on all tutorials altogether.

read more »

Season’s greetings!

SenseTheme Christmas 2018 theme

Season’s greetings from QlikFix / Bitmetric! Just a quick little post to direct your attention to the SenseTheme Gallery, where we’ve just added a Christmas 2018 theme by our colleague Gwenny Sonneville.

And since we like being prepared, our colleague Bernard de Bruin has already created additional themes for winter, spring and summer 😉

Wishing all of you happy holidays and all the best for the new year!

For those of your who are interested in that sort of thing, below you can find some stats on SenseTheme usage in 2018

read more »

SenseTheme: Theme Builder for Qlik Sense

SenseTheme

TL;DR: check out SenseTheme.

At Bitmetric, my colleagues and I regularly meet after work to investigate and experiment with interesting methods and technologies, share knowledge and generally shoot the breeze (we’re all at different client sites during the week, so it’s a good time to catch up).

The topic of our last meetup was Qlik Sense Themes. This is one of the big new (and highly anticipated) features in the Qlik Sense February 2018 release, allowing you to create custom themes for your apps. Our expectation was that we’d get the general idea of themes, go over the syntax and build a few cool themes. In reality, our meetup quickly devolved into a hunt for missing curly braces, property names and CSS classes. Still fun, if you’re into that sort of thing, but not as productive as we’d hoped.

read more »

Extracting embedded images from QlikView

ImageExtractor for QlikView

ImageExtractor for QlikView

ImageExtractor is a small utility that extracts images from your QlikView applications and stores them as bitmaps. It also gives you a browser that tells you which images are used in which QlikView application.

read more »