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

Webofwork

Webofwork

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

Streams are kind of like user groups. Here are the key points about Qlik Sense Streams: A stream enables users to read and/or publish apps, sheets, and stories. Users who have publish access to a stream, create the content for that specific stream. The stream access pattern in a Qlik Sense site is determined by the security rules for each stream. By default, Qlik Sense includes two streams: Everyone...

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

Datamarket is an attempt to give you access to reliable external data such as Weather, Demographics to provide insight with your own data set. Practically it means that once you go through the datamarket wizard, it will generate a Load statement that will pull the data you specified into your data model. By default the script will be locked - so it is controlled by the wizard,...

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