New QlikView Mapping Extensions on QlikMarket

[Brian_Munz]

EDIT: These extensions are no longer maintained on QlikMarket since that is not an appropriate place for free and unsupported extensions.  I've modified the links below to point to the github repositories where I now keep them.  Also, since they're now hosted on github, feel free to make contributions to the code.

Hi everyone,

The demand for mapping in QlikView seems to be a hot topic these days, so I’ve put together two extensions that are now available on QlikMarket bearing the QlikView name.

The first one is an extension which uses SVG images to connect to the data and color and shade the regions in that image:

brianwmunz/svgReader-QV11 · GitHub

Similar to this map of US Counties:

There’s no geospatial connection here (long/lat points can’t be plotted, etc.), but it should prove useful for a lot of simple needs and uses for visualization of a geographical entity.  It comes prepackaged with 35 or so maps of countries, etc. and also offers the ability to load in your own custom SVGs for things like floor plans, seating charts, etc.

The second extension is a simple geospatial mapping extension similar to the Google Maps and various other extensions you might have seen in community:

brianwmunz/QuickMap-QV11 · GitHub

This extension simply takes geographic data (longitude/latitude points) from QlikView and draws it over a map.  It supports the drawing of dots, lines, or polygon shapes.  For example:

This doesn’t offer near the capabilities of a server based geospatial mapping solution like ESRI, GeoQlik, Idevio, etc. simply because it’s not server side, but it should be helpful for less heavy and complex mapping needs.

Anyway, I hear a lot about need for mapping so I thought I’d let everyone know.

[mikkeltaylor]

Getting closer!  How do I get Scotland & Wales into this map?

[Julie_Main]

Unfortunately, I was only able to find an SVG of England .. you can only put Scotland in if you find an SVG that has it .. Sorry!  I am on the look out, so if I ever find one, will let you know!

[mikkeltaylor]

No worries, thanks Julie.  I did try and add Scotland from the regions svg, but it badly overlapped the top of England.

im going to attempt to fix this tomorrow or just settle for the regions map tomorrow.  Will post back on here if I have any luck.

michael.

[mikkeltaylor]

Hi,

Just an update.  I managed to get the UK regions.svg file working ok, but did't get anywhere with obtain a complete counties svg file. 

Hoping this will be resolved properly in Qlikview.next  Ideally I would want to pass in a postcode and have much greater drill down capabilities.

[sathishkumar_go]

Hi Brian,

I have downloaded the SVG Map.

I am facing some issues in Europe & UK Conuntries.

Please find the below error:

I am using QlikView 11 sr2 and IE 8.

Anything I have missed?

Regards

Sathish

[Brian_Munz]

You’re using one of the built in maps or your own custom SVG?

I would check your data by building a straight table that contains the same properties as the extension. It appears as if the javascript is having a hard time dealing with the amount of data.

[#8]

Hi Brian,

I want to use a heatmap for US at DMA(Designated Market Area) level. What are the changes i need to make in the existing extension? Do i need to just download a svg image of the US-DMA level map and place it in the extension folder with other maps and then use it directly in the application or something else?

[marc_behrens]

Hi Brian,

thanks for this great extensions.

I guess our .qvw is a bit special, because I did not find any post describing the same "problem" I'm experiencing:

I attached a little example. The demo-eata get's displayed correctly, but we don't use the tabrow in our application, it's hidden. That's why we use actions, to switch sheets. (I think it's not a Problem with your extension, but QlikView itself. Unfortunately getting rid of the QlikView bug might be a bit of more work, then adjusting the extension)

In the qvw, I numbered the objects (1) to (6), so you can click them in the discribed order and reproduce my problem (it's QV 11.2 SR 4 and IE10).

I think that QlikView does handle the tabrow different than actions. For example:

If you switch sheets and select the one with the extension again (via Tabrow), everything works fine.

If you switch sheets and select the one with the extension (via actions), the extension object is show (border, caption), but no svg map inside.

The reason why I think this is a QV-bug is, becaus we already encountered it when using "on activate sheet"-triggers.

I used to set a variable with an on activate-sheet Trigger, which did not work when using Actions, instead of the tabrow. 😕

This case is also included in the example .qvw. The interesting thing is, it does work without the webview.

Long Story short:

I think your extensions works like it should, but QlikView in webview does trigger the wrong function and as a result, the content is not renderd when it should.

It would be awesome if you could adjust the extension, that it works with the current behavior of QlikView (I think it must be possible, because it works correct the first time the object gets displayed. It's just not told to rerender on switching sheets by QlikView)

In addition, I observed another behavior- which i could not reproduce whenever I wanted. I Think it occured after saving the .qvw (only seen using QlikView Desktop so far). For example when clicking clear all, it "drops" some of the svgs elements (left image).

Kind regards,

Marc

(P.S. If you could include the object ID in the property, that would help with sourcecontrolling the .XML files )

[#10]

Brian, look into using Modernizr: the feature detection library for HTML5/CSS3 for checking SVG support.  The library is very tiny and instead of checking user agents, it actually attempts to create a SVG object. If it fails, it will return an error which you can then add logic around to fall back to html instead.

[Brian_Munz]

Thanks.  Yeah, when I get some time I plan on using modernizr to detect SVG support, and if the user supports it, simply embed the SVG on the page.  If the browser does not support it, it will fall back on the current version of the svg extension which draws out the image using Raphael.