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://i1.wp.com/community.qlikview.com/servlet/JiveServlet/showImage/2-253721-21037/QlikView_foursquare.png

Advertisements

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

Document Extension – iPad detection

4 Comments

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

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.

Dynamic DIV-tag integration

2 Comments

With QlikView 11 we introduced a feature with the sexy name DIV-tag integration.
What this really enables us to do is to reference our JavaScript API and integrate QlikView Objects into web solutions with full functionality.

This is huge. With no extra licenses QlikView users around the world can now enjoy QlikView functionality within non .Net solutions, embedded into their ERP or CRM systems. The community loved it but was also a bit concerned that the amount of objects floating around out there would increase the maintenance of QlikView.

A few lines of JavaScript will eliminate that problem for you 🙂

I give you: Dynamic DIV-tag integration 1.0
Now you have 1 solution to maintain that can serve your entire company with embedded QlikView Objects.

Short version (long version walking through the code will be a separate post):

You will need:
QlikView Server version 11 installed.
Some sort of web server.
A can of coke and a smile on your face.

Installation:
1. Download the sample at: http://dl.dropbox.com/u/18211954/script.zip
2. If you are running QV Webserver extract the contents to: C:\Program Files\QlikView\Web
3. And you are done.

How-to:
The solution accepts input according to the following syntax: http://WebServerUrl/app pool/single.htm?app=your document without qvw&obj=ObjectID
Optional parameters are w and h to set width and height otherwise default to 100%

On my demo system the following URL will generate the chart below:
http://localhost/QlikView/single.htm?app=Vinguiden&obj=CH233&w=200&h=400

This chart has full QlikView functionality. If you for some reason want to disable any interaction with the object, set it to read-only in the QV document.

QlikView Hockey App

Leave a comment

Have you seen the Hockey application we developed for the championship?
Hockey App

It’s all done in QlikView desktop, no workbench shenanigans, with two document extensions embedded into the app.
The first to remove the toolbar that we ship with QlikView. Back before QlikView 11 you had to hack opendoc.htm to make this possible. Not only was it not supported it was also a nightmare to maintain. Now with a few lines of code you can achieve the same thing but without any support issues.

You can download the sample here: http://dl.dropbox.com/u/18211954/Extensions/nobar.qar

The second little feature we snuck in there was that we hooked into the browser event for when you unload the body contents. That is when you leave our site by any means, closing the browser, navigating to a different url or closing the tab the site was opened in.

Now why do we do this? When you deploy an ajax application the RAM-footprint will be somewhat larger then the IE-plugin on the server. This is since we do cache something called user state that contains selection states and graphical components, which this application is _very_ heavy on.

So when you leave our site we kill your session. Normally we would have a time out period that would have to expire before we killed your session but with any public facing solution we might just as well kill it when you leave the app.
What this also enables is that we now can track REAL time spent on the site through our session logging.

Go download at: http://dl.dropbox.com/u/18211954/Extensions/KillSession.qar

Word Cloud Extension

1 Comment

Ok. I’m possibly the worst blogger in the world. I guess since if I want to share something I gotta do it in like 5 different places and then the blog gets cut when I run out of time. Any advice on good cross posting applications?

Also if you across any cool stuff on the web that you think might look good in #QlikView, drop me a line and I’ll see what I can do. Running out of ideas here…
Anyways. here is a small word cloud extension I put together for a customer. It’s based upon tagcanvas and should work in any browser, only tested in modern ones.
Both size and color scaling on amount of tags. Some preferences exposed in QlikView the others you have to modify the script if you want to play around with it.

If you are running QlikView 10 I have not put together a properties page so you will end up with standard configuration.
Go download it at: http://dl.dropbox.com/u/18211954/Extensions/WordCloud.zip

Twitter Feed inside QlikView

2 Comments

We are finally getting around to putting up our monitors, that has been sitting in boxes for ages, on the walls at the office.
So instead of showing off boring numbers like sales pipeline, consultancy availability and stuff like that why not show case what’s being said about us in the twitterverse?

So here is a small extension for just that, search twitter for keywords with real time updates (well I hardcoded a 30s refresh rate…)
Example app and the extension can found here for a limited time: http://dl.dropbox.com/u/18211954/Extensions/LiveTwitterStream.zip

Screenshot of the result, seems the Japanese just woke up:

 

Older Entries Newer Entries