Tag Archive for Mapping

Cloudmade – We hardly knew thee

Hey all!

I recently reviewed some of my geoJson mapping experiments with PA School districts and New York counties, I noticed that the map tiles weren’t rendering.  After pulling up chrome developer, I quickly noticed that the tile sets were posting 404 errors. It seems a few months ago that Cloudmade “shut it doors” on the free apis and switched to servicing paying customers (the shame!).  I found a quick and easy replacement with Mapbox after reading some good reviews and easy conversion stories by folks switching from Cloudmade.  I just made the changes so my maps are good to go! Additionally, I will be pushing changes to the QlikView mapping extension on GitHub sometime this week with these changes and some additions! Stay tuned!

Tinkering with Qlikview extensions

Hey all!

I’ve been keeping myself busy with learning and implementing extensions for QlikView.  Extensions in QlikView are basically self-contained javascript div’s that are executed on each page load/refresh.  The programming flow is like so:

  • add javascript libraries and css as needed (LeafletJS and Google Maps for instance)
  • add the extension with the QlikView Call (Qva.LoadExtension)
  • add your special sauce! (I.E. What you need to do)

I always wanted to learn how to add extensions and with the help of a fellow redditor, we started tinkering with D3.js library in QlikView.  Our attempts can be viewed on GitHub and are completely free for your use (Located here)

Once I learned the basics, I wanted to create some maps with QlikView.  Currently, the only offering for mapping in QlikView was with third party product that needed to be purchased.  I came up with the idea of using LeafletJS because of the simple API calls to append the map containers to the HTML, markers and other mapping layers.  Additionally, Leaflet JS allows you to use your own choice of tile layers (i.e. Cloudmade, OpenStreetMaps, Google, etc…) and can allow the user to switch between them with a simple button click.  I opted to use Google as most users are familiar the map style and the fact that the usage for them is pretty reasonable (read free with limits).  Also,  I wanted to be able to auto-cluster the data points so I included the Leaflet marker cluster repo as well (find it here).

With that, I want to promote my working Leaflet Qlikview Extension that I’m releasing under the GPL V2 license.  Check it out on my QlikViewMaps repo and feel free to fork it!  Also, I have included a screenshot of my extension that I’m using for my current employer.  We are thinking of using the extension to map all of the current qualcomm events (30 min lag) with selectors to breakdown tractors, drivers and workflow event type.


My first extension for QlikView - Leaflet JS Maps

My first extension for QlikView – Leaflet JS Maps