Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Not applicable

APPLYMAP comma separated with more values possible?


I Currently have following code (example):





Resident PROVINCE;


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
MVP & Luminary
MVP & Luminary

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