The Konami Code

Leave a comment

The Konami Code.
Add this document extension to a document, type the Konami code.
Press some keys for more goodies. 
Soon on a demo near you.

Download link:

I really need to post some more useful posts soon…


QlikFart – Yes it’s exactly what you think it is.

Leave a comment

So the guys over at created this awesome little lib that makes random farting noises when you scroll a page on the internet. Awesome.
Of course we had to adapt it to QV – so here is a implementation of the same library but instead of scrolling it now reacts on clicks within your app. Even more awesome!

  1. Make sure you run IE9+ or Chrome.
  2. Download the extension at:
  3. Install it and add it to your favorite document.
  4. Turn up your speakers.
  5. Enjoy a new dimension of business discovery.

I would love to see an implementation where you instead of farting noises have your boss leave you with small tidbits of motivational speeches.
Stay tuned for more very work essential extensions coming this week!

Small update to the Google Maps – Cluster extension.

Leave a comment

Updated the Cluster extension to allow for popup windows when you hover over a marker.
For download links read:

You can style the popup window with standard html tags, for example: ='<B>Total Number of Visits: </B>’ & Sum(CountVisit) & ‘<img src=”×150.jpg“>’


Also fixed some minor bugs in all of the extensions:

  • Increased page height to 200k
  • Fixed a bug with selection a marker that shared latitude with other markers
  • Now suppressing NULL values so should solve several of the stack overflow errors
  • Newer version of markerclustererplus.

Quick update on Google Maps Marker Extension

Leave a comment

Got a request to add in dynamic icon support for markers, so now you can!
You now have the option to specify an expression to handle custom icons. You could either let it be a static image, =’http://localhost/QlikView/myicon.png&#8217;, or calculate the icon dynamically based on your data. If you do not specify an url the extension will default back to Googles standard marker.

Download link:

Here is an example where I plot high speed cameras in Sweden. If the speed limit is above 80 the icon will be a traffic sign otherwise it’s a beach flag, don’t ask me why…
The beach flag is loaded from an external url where the traffic sign is hosted through my QlikView installation. You could create something more creative – for example plot locations in red if there is X amount of critical support tickets open.


Updates to Google Maps Extensions

1 Comment

So I finally got around to update my Google Maps extensions. There has been tons of discussion on QlikCommunity around features and what you can and can’t do.
So here is three different extensions. Either use them “as is” or use them as a base and change them to suit your specific needs. All extensions now centers correctly and will select a single marker if you click it.

Google Maps – Cluster

Download link:

Perfect when you have a large amount of data points and want to cluster them up for visibility and performance.
Grid Size property controls the size of the cluster grid and max zoom controls how far down you want to cluster markers.


Google Maps – Marker

Download link:

Pretty much the same as the Cluster version except… well you guessed it, without the clustering of markers.
With a large amount of markers expect some performance draw backs.


Google Maps – Heatmap

Download link:

A new addition to the fold. This will produce a heatmap of your data points so you can easily spot a where you have a higher intensity of data points on the map.
There is no selection support for this extension however you could customize the map to turn off the heatmap at a certain zoom level and show normal markers instead.


iPhone settings document extension.

Leave a comment

Perhaps nothing new but I was developing a QlikView app only to be used on the iPhone.
Normally you would want to remove the toolbar and change some meta tags of QlikView. This has been done before but all in separate extensions.

This extensions combines all that. It removes to the toolbar, sets the correct dimensions for the view-port and disables the ability to zoom the page (as we develop the app to fit an iPhone anyways).
I also used an extension to create the menu to avoid rendering text objects but that needs some work before it’s published.



Variance chart

Leave a comment

Edit: WordPress killed the resolution on my images, sorry about that.

Lets assume we want to display expenses vs target across different departments.
In this case the expenses and target for the Sales department are very small and skews our bar chart pretty badly.

Lets express the same information as budget variance in percentage instead.
Delete your expressions and create a new one ( Expenses – Budget) / Budget

Now we can clearly see that Sales has exceeded their expenses budget (as usual!)
Now since this is expenses it can be a bit confusing that negative values actually is a good thing so lets make it even more clear.

Expand your expression and enter this formula as background color, If(Column(1)>0,RGB(170,45,45),RGB(200,200,200))

Personally I like to highlight the budget, 0%, so lets open up the chart properties again. Now add in a reference line, set the expression to 0 and increase line width to 2 pt.

And we are done!

Older Entries