topic Re: Zip Code Analysis in QlikView

Zip Code Analysis

Fri, 13 Nov 2015 15:20:55 GMT

I'm new to Qlikview and need to do an analysis on counts of people from various zip codes. I have tables with the zip,city, state, and long/lat. For someone new to this, what is the best way to add a map that can visualize zip code counts? I tried the Geo heat map from the extensions list in web view but it doesn't give any values and just shows the colored states. Any help would be great-thanks

Re: Zip Code Analysis

Fri, 13 Nov 2015 15:35:57 GMT

Do u have any table Persons related to Zipcode table ?

Can you please share your sample data qvw ? or data model at least ?

Re: Zip Code Analysis

Fri, 13 Nov 2015 16:07:14 GMT

Yes, so I have a distinct ID associated with each zip code that corresponds to a person.

ID CITY STATE ZIPCODE COUNTY LAT LONG

Re: Zip Code Analysis

Sat, 14 Nov 2015 15:42:48 GMT

Hi,

There ar other extensions that are more useful for your needs. For example

IdevioMaps for QlikView can US render US zip code points and areas out of the box.

Here's link to a zip code demo on QlikMarket: http://market.qlik.com/ideviomaps-for-qlik-sense.html

It's made with Sense, but the same can be done with IdevioMaps for QlikView.

Feel free to contact us for a free test license.

Thanks,

Patric Nordström

(disclaimer, I work for Idevio)