Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

APPLYMAP comma separated with more values possible?

Hello,

I Currently have following code (example):

mapcity:

MAPPING LOAD

[PROVINCE.Province],

[PROVINCE.City]

Resident PROVINCE;

CITY:

Load   APPLYMAP ('mapcity', CITY.Province)          as CITY.City,

          .....,

          .....,

From [$(Path)\CITY.qvd]

Because There are more City's in every province it will still only add 1 City to CITY.City.

Is there a possibility that it will add more City's to CITY.City seperated with a comma (,)?

Or do i need to use something else then mapping?

Thanks a lot.

1 Reply

Re: APPLYMAP comma separated with more values possible?

No, you need to use a join instead if you want all the cities added to the provinces.


talk is cheap, supply exceeds demand
Community Browser