APPLYMAP comma separated with more values possible?

Tue, 11 Jun 2013 10:36:03 GMT

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.

Re: APPLYMAP comma separated with more values possible?

Gysbert_Wassenaar — Tue, 11 Jun 2013 10:40:49 GMT

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

topic APPLYMAP comma separated with more values possible? in QlikView

APPLYMAP comma separated with more values possible?

Re: APPLYMAP comma separated with more values possible?