Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
richard_chilvers
Valued Contributor

Set Analysis, AGGR or other ?

I have the following table of postcode areas, with their closest postcode areas, and their adult population.

P/C Area, Near P/C Area, Distance between,  Adults

IPCO15100
IPCM30100
IPSS50100
COCM10130
COEN30130
CMEN14120
SSWF18320

 

I would like to create a chart which lists each P/C Area, with its nearest P/C Area and the population of that near Area, eg.

IP, CO, 130

CO, CM, 120

I have tried and failed to create an expression for the Adults column using set analysis, aggr and other things. So any advice is welcome.

 

Thanks

 

 

Labels (2)