Qlik sense map

Wed, 01 Mar 2017 08:28:47 GMT

Hi my friends,

i want to do something in my map in qlik sense if u cant help me:

for testing i create EXCEL table, where i put all french city's (name, Id_country, Latitude, Longitude, capital)

plus some international city's. for field capital it's Boolean type with(yes, no);

what i need is when someone use my app and he want the Turnover in city like Naples in Italia and Naples doesn't excite in the list of the city's i want the system put the information in the capital of the country like Rome because Rome excite in the list with (capital='yes')

there is want i do it for now:

Binary 'Lib://Test_carte/donnees_Janv_2017.qvw';

Villes01:

LOAD

CTIE as CTIE01,

LTIE as LTIE01,

CPAYS as CPAYS01,

VILLETIE as VILLETIE01

FROM [lib://Villes/Villes.xls]

(biff, embedded labels, table is Feuille2$);

left Join

LOAD

ville as VILLETIE01,

GeoMakePoint(latitude,longitude) as GeoKey01,

pays as CPAYS01,

capitale

FROM [lib://Villes/Villes.xls]

(biff, embedded labels, table is Sheet1$);

Villes02:

Load

CTIE01 as CTIE02,

LTIE01 as LTIE02,

CPAYS01 as CPAYS02

resident Villes01

where not Exists(GeoKey01);

Left Join

LOAD

GeoMakePoint(latitude,longitude) as GeoKey02,

pays as CPAYS02

//capitale

FROM [lib://Villes/Villes.xls]

(biff, embedded labels, table is Sheet1$)

where capitale = 'OUI';

//NoConcatenate;

Villes:

Load CTIE01 as CTIE,

LTIE01 as LTIE,

CPAYS01 as CPAYS,

VILLETIE01 as VILLETIE,

GeoKey01 as GeoKey

resident Villes01;

Concatenate

Load CTIE02 as CTIE,

LTIE02 as LTIE,

CPAYS02 as CPAYS,

GeoKey02 as GeoKey

resident Villes02;

drop tables Villes01, Villes02;

but he doesn't work there is something i missed in the Request.

Thank u for helping me

topic Qlik sense map in App Development

Qlik sense map