Adam Cooke

I currently work as a consultant for Qlik, a software company doing some interesting stuff in business intelligence. Check it out Qlik.com. I write this blog to showcase some technical bits that I hope will be useful to others.
adamcooke@webofwork.com

Tags

Qlik Sense Consulting Tag

Webofwork > Posts tagged "Qlik Sense Consulting"

This extension lets you use videos as a background to your Qlik Sense Dashboard. In this example I connected aerial views of different energy sources to selections made on the dashboard. It certainly adds something eye catching to your standard Qlik sense dashboard. It only works when using Qlik Sense through a browser with Qlik sense desktop or server.     You can use any video URL to...

Read More

Here is a great well built visualisation library that could easily be transformed into a data powered visualisation to use with Qlik. Psychedelic! Here are some horrible monstrosities I created playing around with the JSON config:   [gallery ids="2691,2690,2689,2688"]   Check the library out at http://vincentgarreau.com/particles.js/#default Heres a live demo: See the Pen particles.js by Vincent Garreau (@VincentGarreau) on CodePen. ...

Read More
m

Are you looking for a quick way to turn your excel/csv/text file into an interactive visualization you can embed on your website for free? This post will show you exactly that and it takes about 5 minutes. Maybe you thought about just taking an image from excel or maybe doing something very time consuming with photoshop. Those wont be interactive though...

Read More

Most organisations and people in business intelligence are aware of the term Data Warehouse and its percieved benefits: A Data Warehouse Delivers Enhanced Business Intelligence A Data Warehouse Saves Time A Data Warehouse Enhances Data Quality and Consistency A Data Warehouse Provides Historical Intelligence by storing snapshots from a live system We can actually do these things with Qlik Sense. This is thanks to the powerful Qlik Engine, the great compression speed...

Read More

Sometimes you may have some data that you want to store just within the load script and not have a completely separate data source. You can use an inline table to do this:   TableName: Load * inline [ Month,Quarter 1,Q1 2,Q1 3,Q1 4,Q2 5,Q2 6,Q2 7,Q3 8,Q3 9,Q3 10,Q4 11,Q4 12,Q4 ];   As you can see the fields are comma seperated. This goes directly in the load script and will show up as a new table called 'TableName' in your table viewer. You...

Read More

Extensions are cool and wizzy. They are great for early buy in on a Qlik Sense project, but in production there are some important questions to ask before utilizing them: Who built the extension? How often is the extension updated? Does the extension work with my dataset? Where can I get support if the extension breaks? Does the extension use external css or js files? Are there any license restrictions on...

Read More

If you were wondering how to manage extensions or Mashups in Qlik sense you can do this directly in Qlik Sense Desktop by accessing the new Qlik Sense Dev-Hub. It lets you create and browse mashups and visualisation extensions you have installed on Qlik Sense. It is split into four useful tools:   Single Configurator This page will lets you select an app and then select any object inside...

Read More

Yesterday Qlik released Qlik Sense 2.1. This one has loads of things and is really worth a download, the product is starting to mature and i'm very sure there's loads more to come. The variable editor is back If you are familliar with Qlikview you will be happy that this feature has now returned. Really useful for more complex implementations. This will only be seen in unpublished apps, it...

Read More