Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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