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

Leave a comment

So the guys over at https://github.com/theonion 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: https://dl.dropboxusercontent.com/u/18211954/Extensions/QlikFart.qar
  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!

Advertisements

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: https://mindspank.wordpress.com/2013/03/23/updates-to-google-maps-extensions/

You can style the popup window with standard html tags, for example: ='<B>Total Number of Visits: </B>’ & Sum(CountVisit) & ‘<img src=”http://www.bhsah.com/wp-content/uploads/2010/01/happy-cat1-150×150.jpg“>’

clustercat

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: http://dl.dropbox.com/u/18211954/Extensions/GoogleMaps%20-%20Marker.qar

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.

update

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: http://dl.dropbox.com/u/18211954/Extensions/GoogleMaps%20-%20Cluster.qar

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.

cluster

Google Maps – Marker

Download link: http://dl.dropbox.com/u/18211954/Extensions/GoogleMaps%20-%20Marker.qar

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.

marker

Google Maps – Heatmap

Download link: http://dl.dropbox.com/u/18211954/Extensions/GoogleMaps%20-%20Heatmap.qar

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.

heatmap

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.

Download: http://dl.dropbox.com/u/18211954/Extensions/iPhoneSettings.qar

bild

New Mapping Extension

2 Comments

I’m co-developing a mapping extension together with Ralf Becher, http://www.tiq-solutions.de 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: http://community.qlikview.com/message/253809

https://i0.wp.com/community.qlikview.com/servlet/JiveServlet/showImage/2-253721-21037/QlikView_foursquare.png

Document Extension – Slide out Tabrow

4 Comments

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: http://dl.dropbox.com/u/18211954/Extensions/MenuPaneLeft.qar

Older Entries