https://community.qlik.com/t5/QlikView/Dimension-selection-in-a-chart-set-analysis/m-p/1575089#M442480 <TABLE border="1"><TBODY><TR><TD>Outcode</TD><TD>Neighbour</TD><TD>Distance</TD><TD>Adults</TD></TR><TR><TD>IP</TD><TD>CO</TD><TD>20</TD><TD>2000</TD></TR><TR><TD>CO</TD><TD>SS</TD><TD>30</TD><TD>1000</TD></TR><TR><TD>CO</TD><TD>EN</TD><TD>50</TD><TD>5000</TD></TR><TR><TD>BN</TD><TD>TN</TD><TD>55</TD><TD>4500</TD></TR><TR><TD>SS</TD><TD>WW</TD><TD>40</TD><TD>3300</TD></TR><TR><TD>EN</TD><TD>ZZ</TD><TD>100</TD><TD><P>2200</P></TD></TR><TR><TD><P>TN</P><P>&nbsp;</P></TD><TD>RR</TD><TD>90</TD><TD>7000</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I have the above table of postcode areas, the distance to their postcode area neighbours, and the number of adults in each postcode area.</P><P>I want a chart which shows (for a selection of postcode areas) the postcode area, its <U>nearest</U> neighbour, and the number of adults in that neighbour.</P><P>CO, SS, 3300</P><P>BN, TN, 7000</P><P>&nbsp;</P><P>Ideas please ! Do I need set analysis ?</P><P>&nbsp;</P><P>Thanks</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 16 Nov 2024 03:42:46 GMT richard_chilvers 2024-11-16T03:42:46Z https://community.qlik.com/t5/QlikView/Dimension-selection-in-a-chart-set-analysis/m-p/1575089#M442480 <TABLE border="1"><TBODY><TR><TD>Outcode</TD><TD>Neighbour</TD><TD>Distance</TD><TD>Adults</TD></TR><TR><TD>IP</TD><TD>CO</TD><TD>20</TD><TD>2000</TD></TR><TR><TD>CO</TD><TD>SS</TD><TD>30</TD><TD>1000</TD></TR><TR><TD>CO</TD><TD>EN</TD><TD>50</TD><TD>5000</TD></TR><TR><TD>BN</TD><TD>TN</TD><TD>55</TD><TD>4500</TD></TR><TR><TD>SS</TD><TD>WW</TD><TD>40</TD><TD>3300</TD></TR><TR><TD>EN</TD><TD>ZZ</TD><TD>100</TD><TD><P>2200</P></TD></TR><TR><TD><P>TN</P><P>&nbsp;</P></TD><TD>RR</TD><TD>90</TD><TD>7000</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I have the above table of postcode areas, the distance to their postcode area neighbours, and the number of adults in each postcode area.</P><P>I want a chart which shows (for a selection of postcode areas) the postcode area, its <U>nearest</U> neighbour, and the number of adults in that neighbour.</P><P>CO, SS, 3300</P><P>BN, TN, 7000</P><P>&nbsp;</P><P>Ideas please ! Do I need set analysis ?</P><P>&nbsp;</P><P>Thanks</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 16 Nov 2024 03:42:46 GMT https://community.qlik.com/t5/QlikView/Dimension-selection-in-a-chart-set-analysis/m-p/1575089#M442480 richard_chilvers 2024-11-16T03:42:46Z