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

Hello! This is a file that contains all longitude and latitudes for the US zip codes. It has proven really useful for Qlik Sense Mapping visualizations. It contains the latitude and longitude of every United States zipcode. It also includes the City, State and County of eaech zip code. You can use this file in a tool like Qlik Sense to make fancy maps like the one below: You can...

Read More
ukpostcodes

Hello! This is a file I created by scraping data from a freely available Geographical API. It has proven really useful for Qlik Sense Mapping visualizations. It contains the latitude and longitude of every uk postcode. It also includes the Easting, Northing, Grid Reference, District, Ward, District Code, Ward Code and Country.   You can use this file in a tool like Qlik Sense to make fancy maps like...

Read More

Recently I was trying to use dates as one of the dimensions inside an extension.   Qlik can deal with lots of types of dates, when they are passed to the extension they come through in both a text format in the way they were formatted within Qlik using the date time functions and the Qlik Serial Number. This is handy, but since I wanted the extension to work...

Read More

Personally, I don't have anything against a pie chart in the right context. Some people hate pie charts/donut charts, I do not hold such strong views. Really when considering using a pie chart with a dynamic tool like Qlik Sense or Tableau, it's more about understanding the context. Pie Charts are one of the best visualizations when they are comparing two values in a snapshot. They are also one...

Read More
linechartmini

One of the easiest charts to create in Qlik Sense or Excel or any BI tool is a line chart. Very good for showing trends over time but also very easy to make look like spaghetti or a pile of string if not thought about correctly.   See what I mean?   Here are a couple of alternatives while still using the line chart to make the data more readable. Use space to...

Read More
particle.js visualisations

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
network

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