topic Re: QS Server issues with map in November update in App Development https://community.qlik.com/t5/App-Development/QS-Server-issues-with-map-in-November-update/m-p/1423484#M33890 <HTML><HEAD></HEAD><BODY><P>Hello Gareth, </P><P></P><P>I found a workaround to the issue, Please follow the following steps.</P><P></P><P>Step 1 : Create a static table contains all countries&nbsp; as the following </P><P></P><P>Countries:</P><P>load * Inline</P><P>[</P><P>Country_Name,Country_ISO</P><P>Afghanistan,AF</P><P>Ã…land Islands,AX</P><P>Albania,AL</P><P>Algeria,DZ</P><P>American Samoa,AS</P><P>Andorra,AD</P><P>Angola,AO</P><P>Anguilla,AI</P><P>Antarctica,AQ</P><P>Antigua and Barbuda,AG</P><P>Argentina,AR</P><P>Armenia,AM</P><P>Aruba,AW</P><P>Australia,AU</P><P>Austria,AT</P><P>Azerbaijan,AZ</P><P>Bahamas,BS</P><P>Bahrain,BH</P><P>Bangladesh,BD</P><P>Barbados,BB</P><P>Belarus,BY</P><P>Belgium,BE</P><P>Belize,BZ</P><P>Benin,BJ</P><P>Bermuda,BM</P><P>Bhutan,BT</P><P>"Bolivia, Plurinational State of",BO</P><P>"Bonaire, Sint Eustatius and Saba",BQ</P><P>Bosnia and Herzegovina,BA</P><P>Botswana,BW</P><P>Bouvet Island,BV</P><P>Brazil,BR</P><P>British Indian Ocean Territory,IO</P><P>Brunei Darussalam,BN</P><P>Bulgaria,BG</P><P>Burkina Faso,BF</P><P>Burundi,BI</P><P>Cambodia,KH</P><P>Cameroon,CM</P><P>Canada,CA</P><P>Cape Verde,CV</P><P>Cayman Islands,KY</P><P>Central African Republic,CF</P><P>Chad,TD</P><P>Chile,CL</P><P>China,CN</P><P>Christmas Island,CX</P><P>Cocos (Keeling) Islands,CC</P><P>Colombia,CO</P><P>Comoros,KM</P><P>Congo,CG</P><P>"Congo, the Democratic Republic of the",CD</P><P>Cook Islands,CK</P><P>Costa Rica,CR</P><P>Côte d'Ivoire,CI</P><P>Croatia,HR</P><P>Cuba,CU</P><P>Curaçao,CW</P><P>Cyprus,CY</P><P>Czech Republic,CZ</P><P>Denmark,DK</P><P>Djibouti,DJ</P><P>Dominica,DM</P><P>Dominican Republic,DO</P><P>Ecuador,EC</P><P>Egypt,EG</P><P>El Salvador,SV</P><P>Equatorial Guinea,GQ</P><P>Eritrea,ER</P><P>Estonia,EE</P><P>Ethiopia,ET</P><P>Falkland Islands (Malvinas),FK</P><P>Faroe Islands,FO</P><P>Fiji,FJ</P><P>Finland,FI</P><P>France,FR</P><P>French Guiana,GF</P><P>French Polynesia,PF</P><P>French Southern Territories,TF</P><P>Gabon,GA</P><P>Gambia,GM</P><P>Georgia,GE</P><P>Germany,DE</P><P>Ghana,GH</P><P>Gibraltar,GI</P><P>Greece,GR</P><P>Greenland,GL</P><P>Grenada,GD</P><P>Guadeloupe,GP</P><P>Guam,GU</P><P>Guatemala,GT</P><P>Guernsey,GG</P><P>Guinea,GN</P><P>Guinea-Bissau,GW</P><P>Guyana,GY</P><P>Haiti,HT</P><P>Heard Island and McDonald Islands,HM</P><P>Holy See (Vatican City State),VA</P><P>Honduras,HN</P><P>Hong Kong,HK</P><P>Hungary,HU</P><P>Iceland,IS</P><P>India,IN</P><P>Indonesia,ID</P><P>"Iran, Islamic Republic of",IR</P><P>Iraq,IQ</P><P>Ireland,IE</P><P>Isle of Man,IM</P><P>Israel,IL</P><P>Italy,IT</P><P>Jamaica,JM</P><P>Japan,JP</P><P>Jersey,JE</P><P>Jordan,JO</P><P>Kazakhstan,KZ</P><P>Kenya,KE</P><P>Kiribati,KI</P><P>"Korea, Democratic People's Republic of",KP</P><P>"Korea, Republic of",KR</P><P>Kuwait,KW</P><P>Kyrgyzstan,KG</P><P>Lao People's Democratic Republic,LA</P><P>Latvia,LV</P><P>Lebanon,LB</P><P>Lesotho,LS</P><P>Liberia,LR</P><P>Libya,LY</P><P>Liechtenstein,LI</P><P>Lithuania,LT</P><P>Luxembourg,LU</P><P>Macao,MO</P><P>"Macedonia, the Former Yugoslav Republic of",MK</P><P>Madagascar,MG</P><P>Malawi,MW</P><P>Malaysia,MY</P><P>Maldives,MV</P><P>Mali,ML</P><P>Malta,MT</P><P>Marshall Islands,MH</P><P>Martinique,MQ</P><P>Mauritania,MR</P><P>Mauritius,MU</P><P>Mayotte,YT</P><P>Mexico,MX</P><P>"Micronesia, Federated States of",FM</P><P>"Moldova, Republic of",MD</P><P>Monaco,MC</P><P>Mongolia,MN</P><P>Montenegro,ME</P><P>Montserrat,MS</P><P>Morocco,MA</P><P>Mozambique,MZ</P><P>Myanmar,MM</P><P>Namibia,NA</P><P>Nauru,NR</P><P>Nepal,NP</P><P>Netherlands,NL</P><P>New Caledonia,NC</P><P>New Zealand,NZ</P><P>Nicaragua,NI</P><P>Niger,NE</P><P>Nigeria,NG</P><P>Niue,NU</P><P>Norfolk Island,NF</P><P>Northern Mariana Islands,MP</P><P>Norway,NO</P><P>Oman,OM</P><P>Pakistan,PK</P><P>Palau,PW</P><P>"Palestine, State of",PS</P><P>Panama,PA</P><P>Papua New Guinea,PG</P><P>Paraguay,PY</P><P>Peru,PE</P><P>Philippines,PH</P><P>Pitcairn,PN</P><P>Poland,PL</P><P>Portugal,PT</P><P>Puerto Rico,PR</P><P>Qatar,QA</P><P>Réunion,RE</P><P>Romania,RO</P><P>Russian Federation,RU</P><P>Rwanda,RW</P><P>Saint Barthélemy,BL</P><P>"Saint Helena, Ascension and Tristan da Cunha",SH</P><P>Saint Kitts and Nevis,KN</P><P>Saint Lucia,LC</P><P>Saint Martin (French part),MF</P><P>Saint Pierre and Miquelon,PM</P><P>Saint Vincent and the Grenadines,VC</P><P>Samoa,WS</P><P>San Marino,SM</P><P>Sao Tome and Principe,ST</P><P>Saudi Arabia,SA</P><P>Senegal,SN</P><P>Serbia,RS</P><P>Seychelles,SC</P><P>Sierra Leone,SL</P><P>Singapore,SG</P><P>Sint Maarten (Dutch part),SX</P><P>Slovakia,SK</P><P>Slovenia,SI</P><P>Solomon Islands,SB</P><P>Somalia,SO</P><P>South Africa,ZA</P><P>South Georgia and the South Sandwich Islands,GS</P><P>South Sudan,SS</P><P>Spain,ES</P><P>Sri Lanka,LK</P><P>Sudan,SD</P><P>Suriname,SR</P><P>Svalbard and Jan Mayen,SJ</P><P>Swaziland,SZ</P><P>Sweden,SE</P><P>Switzerland,CH</P><P>Syrian Arab Republic,SY</P><P>"Taiwan, Province of China",TW</P><P>Tajikistan,TJ</P><P>"Tanzania, United Republic of",TZ</P><P>Thailand,TH</P><P>Timor-Leste,TL</P><P>Togo,TG</P><P>Tokelau,TK</P><P>Tonga,TO</P><P>Trinidad and Tobago,TT</P><P>Tunisia,TN</P><P>Turkey,TR</P><P>Turkmenistan,TM</P><P>Turks and Caicos Islands,TC</P><P>Tuvalu,TV</P><P>Uganda,UG</P><P>Ukraine,UA</P><P>United Arab Emirates,AE</P><P>United Kingdom,GB</P><P>United States,US</P><P>United States Minor Outlying Islands,UM</P><P>Uruguay,UY</P><P>Uzbekistan,UZ</P><P>Vanuatu,VU</P><P>"Venezuela, Bolivarian Republic of",VE</P><P>Viet Nam,VN</P><P>"Virgin Islands, British",VG</P><P>"Virgin Islands, U.S.",VI</P><P>Wallis and Futuna,WF</P><P>Western Sahara,EH</P><P>Yemen,YE</P><P>Zambia,ZM</P><P>Zimbabwe,ZW] ;</P><P></P><P>Step 2 : concatenate the countries from the previous table&nbsp; to your original table as the following .</P><P>Note Don't forget to rename the fields from the Countries table to be same&nbsp; name as fields from you original table. </P><P></P><P></P><P>Concatenate</P><P>Load Upper(Country_Name) as "Account Bank Country" ,Upper(Country_ISO) as "Country_ISO_acc"</P><P>Resident Countries;</P><P></P><P>Step 3 : drop countries table .</P><P></P><P>drop table Countries;</P><P></P><P>Step 4&nbsp; : load KML file data as the following </P><P></P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp; UPPER(World_ISO2.Name) AS "Country_ISO_acc",</P><P>&nbsp;&nbsp;&nbsp; World_ISO2.Area as Area_acc</P><P>&nbsp;&nbsp;&nbsp; FROM [lib://Your-Folder\World_ISO2.kml]</P><P>&nbsp;&nbsp; (kml, Table is [world_ISO2]);</P><P></P><P></P><P>Thanks,</P><P>Ahmed</P><P></P><P></P><P></P><P><SPAN style="font-size: 10pt;"> </SPAN></P></BODY></HTML> Fri, 26 Jan 2018 14:00:30 GMT ahmed_salah 2018-01-26T14:00:30Z QS Server issues with map in November update https://community.qlik.com/t5/App-Development/QS-Server-issues-with-map-in-November-update/m-p/1423481#M33887 <HTML><HEAD></HEAD><BODY><P>The following rendering error occurs following the November update of Qlik Sense Server.</P><P></P><P>Has anyone experienced a similar issue?</P><P>I've checked the world.kml and ISO countries.qvd we downloaded from the community and the files aren't corrupted.</P><P></P><P>Exact same dataset working on previous version <span class="lia-unicode-emoji" title=":confused_face:">😕</span></P><P></P><P><IMG alt="MapError.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/183871_MapError.PNG" style="height: 265px; width: 620px;" /></P></BODY></HTML> Mon, 20 Nov 2017 09:33:50 GMT https://community.qlik.com/t5/App-Development/QS-Server-issues-with-map-in-November-update/m-p/1423481#M33887 Anonymous 2017-11-20T09:33:50Z Re: QS Server issues with map in November update https://community.qlik.com/t5/App-Development/QS-Server-issues-with-map-in-November-update/m-p/1423482#M33888 <HTML><HEAD></HEAD><BODY><P>any updates regarding this issue.</P></BODY></HTML> Thu, 11 Jan 2018 20:28:25 GMT https://community.qlik.com/t5/App-Development/QS-Server-issues-with-map-in-November-update/m-p/1423482#M33888 ahmed_salah 2018-01-11T20:28:25Z Re: QS Server issues with map in November update https://community.qlik.com/t5/App-Development/QS-Server-issues-with-map-in-November-update/m-p/1423483#M33889 <HTML><HEAD></HEAD><BODY><P>No, sorry Ahmed. We still have the same issue and no-one else has replied</P></BODY></HTML> Fri, 12 Jan 2018 10:02:22 GMT https://community.qlik.com/t5/App-Development/QS-Server-issues-with-map-in-November-update/m-p/1423483#M33889 Anonymous 2018-01-12T10:02:22Z Re: QS Server issues with map in November update https://community.qlik.com/t5/App-Development/QS-Server-issues-with-map-in-November-update/m-p/1423484#M33890 <HTML><HEAD></HEAD><BODY><P>Hello Gareth, </P><P></P><P>I found a workaround to the issue, Please follow the following steps.</P><P></P><P>Step 1 : Create a static table contains all countries&nbsp; as the following </P><P></P><P>Countries:</P><P>load * Inline</P><P>[</P><P>Country_Name,Country_ISO</P><P>Afghanistan,AF</P><P>Ã…land Islands,AX</P><P>Albania,AL</P><P>Algeria,DZ</P><P>American Samoa,AS</P><P>Andorra,AD</P><P>Angola,AO</P><P>Anguilla,AI</P><P>Antarctica,AQ</P><P>Antigua and Barbuda,AG</P><P>Argentina,AR</P><P>Armenia,AM</P><P>Aruba,AW</P><P>Australia,AU</P><P>Austria,AT</P><P>Azerbaijan,AZ</P><P>Bahamas,BS</P><P>Bahrain,BH</P><P>Bangladesh,BD</P><P>Barbados,BB</P><P>Belarus,BY</P><P>Belgium,BE</P><P>Belize,BZ</P><P>Benin,BJ</P><P>Bermuda,BM</P><P>Bhutan,BT</P><P>"Bolivia, Plurinational State of",BO</P><P>"Bonaire, Sint Eustatius and Saba",BQ</P><P>Bosnia and Herzegovina,BA</P><P>Botswana,BW</P><P>Bouvet Island,BV</P><P>Brazil,BR</P><P>British Indian Ocean Territory,IO</P><P>Brunei Darussalam,BN</P><P>Bulgaria,BG</P><P>Burkina Faso,BF</P><P>Burundi,BI</P><P>Cambodia,KH</P><P>Cameroon,CM</P><P>Canada,CA</P><P>Cape Verde,CV</P><P>Cayman Islands,KY</P><P>Central African Republic,CF</P><P>Chad,TD</P><P>Chile,CL</P><P>China,CN</P><P>Christmas Island,CX</P><P>Cocos (Keeling) Islands,CC</P><P>Colombia,CO</P><P>Comoros,KM</P><P>Congo,CG</P><P>"Congo, the Democratic Republic of the",CD</P><P>Cook Islands,CK</P><P>Costa Rica,CR</P><P>Côte d'Ivoire,CI</P><P>Croatia,HR</P><P>Cuba,CU</P><P>Curaçao,CW</P><P>Cyprus,CY</P><P>Czech Republic,CZ</P><P>Denmark,DK</P><P>Djibouti,DJ</P><P>Dominica,DM</P><P>Dominican Republic,DO</P><P>Ecuador,EC</P><P>Egypt,EG</P><P>El Salvador,SV</P><P>Equatorial Guinea,GQ</P><P>Eritrea,ER</P><P>Estonia,EE</P><P>Ethiopia,ET</P><P>Falkland Islands (Malvinas),FK</P><P>Faroe Islands,FO</P><P>Fiji,FJ</P><P>Finland,FI</P><P>France,FR</P><P>French Guiana,GF</P><P>French Polynesia,PF</P><P>French Southern Territories,TF</P><P>Gabon,GA</P><P>Gambia,GM</P><P>Georgia,GE</P><P>Germany,DE</P><P>Ghana,GH</P><P>Gibraltar,GI</P><P>Greece,GR</P><P>Greenland,GL</P><P>Grenada,GD</P><P>Guadeloupe,GP</P><P>Guam,GU</P><P>Guatemala,GT</P><P>Guernsey,GG</P><P>Guinea,GN</P><P>Guinea-Bissau,GW</P><P>Guyana,GY</P><P>Haiti,HT</P><P>Heard Island and McDonald Islands,HM</P><P>Holy See (Vatican City State),VA</P><P>Honduras,HN</P><P>Hong Kong,HK</P><P>Hungary,HU</P><P>Iceland,IS</P><P>India,IN</P><P>Indonesia,ID</P><P>"Iran, Islamic Republic of",IR</P><P>Iraq,IQ</P><P>Ireland,IE</P><P>Isle of Man,IM</P><P>Israel,IL</P><P>Italy,IT</P><P>Jamaica,JM</P><P>Japan,JP</P><P>Jersey,JE</P><P>Jordan,JO</P><P>Kazakhstan,KZ</P><P>Kenya,KE</P><P>Kiribati,KI</P><P>"Korea, Democratic People's Republic of",KP</P><P>"Korea, Republic of",KR</P><P>Kuwait,KW</P><P>Kyrgyzstan,KG</P><P>Lao People's Democratic Republic,LA</P><P>Latvia,LV</P><P>Lebanon,LB</P><P>Lesotho,LS</P><P>Liberia,LR</P><P>Libya,LY</P><P>Liechtenstein,LI</P><P>Lithuania,LT</P><P>Luxembourg,LU</P><P>Macao,MO</P><P>"Macedonia, the Former Yugoslav Republic of",MK</P><P>Madagascar,MG</P><P>Malawi,MW</P><P>Malaysia,MY</P><P>Maldives,MV</P><P>Mali,ML</P><P>Malta,MT</P><P>Marshall Islands,MH</P><P>Martinique,MQ</P><P>Mauritania,MR</P><P>Mauritius,MU</P><P>Mayotte,YT</P><P>Mexico,MX</P><P>"Micronesia, Federated States of",FM</P><P>"Moldova, Republic of",MD</P><P>Monaco,MC</P><P>Mongolia,MN</P><P>Montenegro,ME</P><P>Montserrat,MS</P><P>Morocco,MA</P><P>Mozambique,MZ</P><P>Myanmar,MM</P><P>Namibia,NA</P><P>Nauru,NR</P><P>Nepal,NP</P><P>Netherlands,NL</P><P>New Caledonia,NC</P><P>New Zealand,NZ</P><P>Nicaragua,NI</P><P>Niger,NE</P><P>Nigeria,NG</P><P>Niue,NU</P><P>Norfolk Island,NF</P><P>Northern Mariana Islands,MP</P><P>Norway,NO</P><P>Oman,OM</P><P>Pakistan,PK</P><P>Palau,PW</P><P>"Palestine, State of",PS</P><P>Panama,PA</P><P>Papua New Guinea,PG</P><P>Paraguay,PY</P><P>Peru,PE</P><P>Philippines,PH</P><P>Pitcairn,PN</P><P>Poland,PL</P><P>Portugal,PT</P><P>Puerto Rico,PR</P><P>Qatar,QA</P><P>Réunion,RE</P><P>Romania,RO</P><P>Russian Federation,RU</P><P>Rwanda,RW</P><P>Saint Barthélemy,BL</P><P>"Saint Helena, Ascension and Tristan da Cunha",SH</P><P>Saint Kitts and Nevis,KN</P><P>Saint Lucia,LC</P><P>Saint Martin (French part),MF</P><P>Saint Pierre and Miquelon,PM</P><P>Saint Vincent and the Grenadines,VC</P><P>Samoa,WS</P><P>San Marino,SM</P><P>Sao Tome and Principe,ST</P><P>Saudi Arabia,SA</P><P>Senegal,SN</P><P>Serbia,RS</P><P>Seychelles,SC</P><P>Sierra Leone,SL</P><P>Singapore,SG</P><P>Sint Maarten (Dutch part),SX</P><P>Slovakia,SK</P><P>Slovenia,SI</P><P>Solomon Islands,SB</P><P>Somalia,SO</P><P>South Africa,ZA</P><P>South Georgia and the South Sandwich Islands,GS</P><P>South Sudan,SS</P><P>Spain,ES</P><P>Sri Lanka,LK</P><P>Sudan,SD</P><P>Suriname,SR</P><P>Svalbard and Jan Mayen,SJ</P><P>Swaziland,SZ</P><P>Sweden,SE</P><P>Switzerland,CH</P><P>Syrian Arab Republic,SY</P><P>"Taiwan, Province of China",TW</P><P>Tajikistan,TJ</P><P>"Tanzania, United Republic of",TZ</P><P>Thailand,TH</P><P>Timor-Leste,TL</P><P>Togo,TG</P><P>Tokelau,TK</P><P>Tonga,TO</P><P>Trinidad and Tobago,TT</P><P>Tunisia,TN</P><P>Turkey,TR</P><P>Turkmenistan,TM</P><P>Turks and Caicos Islands,TC</P><P>Tuvalu,TV</P><P>Uganda,UG</P><P>Ukraine,UA</P><P>United Arab Emirates,AE</P><P>United Kingdom,GB</P><P>United States,US</P><P>United States Minor Outlying Islands,UM</P><P>Uruguay,UY</P><P>Uzbekistan,UZ</P><P>Vanuatu,VU</P><P>"Venezuela, Bolivarian Republic of",VE</P><P>Viet Nam,VN</P><P>"Virgin Islands, British",VG</P><P>"Virgin Islands, U.S.",VI</P><P>Wallis and Futuna,WF</P><P>Western Sahara,EH</P><P>Yemen,YE</P><P>Zambia,ZM</P><P>Zimbabwe,ZW] ;</P><P></P><P>Step 2 : concatenate the countries from the previous table&nbsp; to your original table as the following .</P><P>Note Don't forget to rename the fields from the Countries table to be same&nbsp; name as fields from you original table. </P><P></P><P></P><P>Concatenate</P><P>Load Upper(Country_Name) as "Account Bank Country" ,Upper(Country_ISO) as "Country_ISO_acc"</P><P>Resident Countries;</P><P></P><P>Step 3 : drop countries table .</P><P></P><P>drop table Countries;</P><P></P><P>Step 4&nbsp; : load KML file data as the following </P><P></P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp; UPPER(World_ISO2.Name) AS "Country_ISO_acc",</P><P>&nbsp;&nbsp;&nbsp; World_ISO2.Area as Area_acc</P><P>&nbsp;&nbsp;&nbsp; FROM [lib://Your-Folder\World_ISO2.kml]</P><P>&nbsp;&nbsp; (kml, Table is [world_ISO2]);</P><P></P><P></P><P>Thanks,</P><P>Ahmed</P><P></P><P></P><P></P><P><SPAN style="font-size: 10pt;"> </SPAN></P></BODY></HTML> Fri, 26 Jan 2018 14:00:30 GMT https://community.qlik.com/t5/App-Development/QS-Server-issues-with-map-in-November-update/m-p/1423484#M33890 ahmed_salah 2018-01-26T14:00:30Z