topic Set Analysis, AGGR or other ? in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-AGGR-or-other/m-p/1570344#M442056 <P>I have the following table of postcode areas, with their closest postcode areas, and their adult population.</P><P>P/C Area, Near P/C Area, Distance between, &nbsp;Adults</P><TABLE><TBODY><TR><TD>IP</TD><TD>CO</TD><TD>15</TD><TD>100</TD></TR><TR><TD>IP</TD><TD>CM</TD><TD>30</TD><TD>100</TD></TR><TR><TD>IP</TD><TD>SS</TD><TD>50</TD><TD>100</TD></TR><TR><TD>CO</TD><TD>CM</TD><TD>10</TD><TD>130</TD></TR><TR><TD>CO</TD><TD>EN</TD><TD>30</TD><TD>130</TD></TR><TR><TD>CM</TD><TD>EN</TD><TD>14</TD><TD>120</TD></TR><TR><TD>SS</TD><TD>WF</TD><TD>18</TD><TD>320</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I would like to create a chart which lists each P/C Area, with its nearest P/C Area and&nbsp;the population of that near Area, eg.</P><P>IP, CO, 130</P><P>CO, CM, 120</P><P>I have tried and failed to create an expression for the Adults column using&nbsp;set analysis, aggr and other things. So any advice is welcome.</P><P>&nbsp;</P><P>Thanks</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 16 Nov 2024 03:49:57 GMT richard_chilvers 2024-11-16T03:49:57Z Set Analysis, AGGR or other ? https://community.qlik.com/t5/QlikView/Set-Analysis-AGGR-or-other/m-p/1570344#M442056 <P>I have the following table of postcode areas, with their closest postcode areas, and their adult population.</P><P>P/C Area, Near P/C Area, Distance between, &nbsp;Adults</P><TABLE><TBODY><TR><TD>IP</TD><TD>CO</TD><TD>15</TD><TD>100</TD></TR><TR><TD>IP</TD><TD>CM</TD><TD>30</TD><TD>100</TD></TR><TR><TD>IP</TD><TD>SS</TD><TD>50</TD><TD>100</TD></TR><TR><TD>CO</TD><TD>CM</TD><TD>10</TD><TD>130</TD></TR><TR><TD>CO</TD><TD>EN</TD><TD>30</TD><TD>130</TD></TR><TR><TD>CM</TD><TD>EN</TD><TD>14</TD><TD>120</TD></TR><TR><TD>SS</TD><TD>WF</TD><TD>18</TD><TD>320</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I would like to create a chart which lists each P/C Area, with its nearest P/C Area and&nbsp;the population of that near Area, eg.</P><P>IP, CO, 130</P><P>CO, CM, 120</P><P>I have tried and failed to create an expression for the Adults column using&nbsp;set analysis, aggr and other things. So any advice is welcome.</P><P>&nbsp;</P><P>Thanks</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 16 Nov 2024 03:49:57 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-AGGR-or-other/m-p/1570344#M442056 richard_chilvers 2024-11-16T03:49:57Z