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!

New Mapping Extension


I’m co-developing a mapping extension together with Ralf Becher, which aims to replace any Google maps functionality floating around out there.

This is a completely FREE solution based on CloudMade API’s, sign up for a free api key!, with OpenStreetMap map-tiles.
Currently it supports placing of markers with custom titles, clustering of markers to support large numbers of markers in the same area, single marker selection support back to QV.
More functionality in the pipeline so check back on the community thread for updates.

All fame and glory goes to Ralf for setting this project in motion!

Check it out at:

Document Extension – Slide out Tabrow


I just realized I had forgot to post this one.
Put together a small document extension to showcase how you can manipulate the tabrow in QlikView.

This can also be used as a shell if you want to customize your own tabrow to fit your needs. Change the css and remove the jquery transitions in script.js and you have a good starting point where you can apply your own css styling and you are good to go.

For this sample we moved the tabrow over the left hand side and let it slide out as you hover over with your mouse. I used images instead of text for the tab names in my old sample so haven’t really styled the text to look good. The good thing is that since this is only a re-skin of our tabrow it still retains all the original functionality. Add and remove sheets to your hearts content 🙂

Slide menu download link:

Document Extension – iPad detection


I got a question today from a client where they wanted to adjust their layout of an QlikView App slightly if a user was using QlikView over an iPad.
Today they manage two different apps with different font sizes and tab row settings.

So we wrote a small document extension for them that detects if the users are running an iPad or not and adjust the layout accordingly.
Voila, they reduced their maintenance to one app 🙂

If you want to download a sample you can find it at:

This sample will apply a css file that brings in a web font called Oswald from Google Web Fonts.
Code is documented and can be used as an example on how to load CSS in any document.

Older Entries