9 Mart 2016 Çarşamba

Qlikview static maps reporting

Hi

While trying google map over qlikview  , i faced  with a web-view error ( i guess because of IE10 or something like that) so  i decided to explain how can we  show  our data  over static mapping reports in qlikview.


At first I am gonna prepare my data over an excel file:










And now come back to Qlikview i add following script to read data in excel










After loading our script we have following fields:




















Now we gonna choose an image for our scatter chart.In below  I can see the coordinates of countries.By using  that info  i am gonna create my temp data for country coordinates.


















And now i add my temp data into script section.




















After loading script  , i am adding my scatter chart into my sheet , and specify settings as follows.

1) Choose  Scatter Chart

















2)Dimension tab I am adding COUNTRY field.





















3) For expression tab i am adding  X , Y and SUM(GDP)  as follows
(In my map I just wanna see SUM(GDP) value as popup so i checked the "Text as Popup" for SUM(GDP)





































4) Now for presenting my chart i disable Show X-Y label in order to get a better map view.



















5)Axis tab  should be set as follows. (Scale values has to be specified otherwise data cannot pin the correct spot on the map )


















6) Last part  we gonna set image for our chart in Colors tab.
(Color-->Frame Backgroud--> Image--> ( Set File ) & Check Plot Area Only

















7)Final screen would be look like this