Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Qlik sense map

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

Tags (1)
Community Browser