https://community.qlik.com/t5/App-Development/AGGR-Multiple-Dimensions/m-p/2162419#M94355 <P>Hi</P> <P>I am trying to find a way of analysing data to show where there are multiple dimensions recorded accross different records relative to on another dimension</P> <P>eg as a simplified example, from the data below i want a table that filters on Customer B, as across different records they have in this case different Genders so i want to be able to identify these to check</P> <TABLE style="border-collapse: collapse; width: 144pt;" border="0" width="192" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 14.4pt;"> <TD width="64" height="19" style="height: 14.4pt; width: 48pt;">OrderID</TD> <TD width="64" style="width: 48pt;">Customer</TD> <TD width="64" style="width: 48pt;">Gender</TD> </TR> <TR style="height: 14.4pt;"> <TD height="19" align="right" style="height: 14.4pt;">101</TD> <TD>A</TD> <TD>M</TD> </TR> <TR style="height: 14.4pt;"> <TD height="19" align="right" style="height: 14.4pt;">102</TD> <TD>A</TD> <TD>M</TD> </TR> <TR style="height: 14.4pt;"> <TD height="19" align="right" style="height: 14.4pt;">103</TD> <TD>B</TD> <TD>M</TD> </TR> <TR style="height: 14.4pt;"> <TD height="19" align="right" style="height: 14.4pt;">104</TD> <TD>B</TD> <TD>F</TD> </TR> </TBODY> </TABLE> Wed, 17 Jan 2024 12:55:40 GMT jono19872002 2024-01-17T12:55:40Z https://community.qlik.com/t5/App-Development/AGGR-Multiple-Dimensions/m-p/2162419#M94355 <P>Hi</P> <P>I am trying to find a way of analysing data to show where there are multiple dimensions recorded accross different records relative to on another dimension</P> <P>eg as a simplified example, from the data below i want a table that filters on Customer B, as across different records they have in this case different Genders so i want to be able to identify these to check</P> <TABLE style="border-collapse: collapse; width: 144pt;" border="0" width="192" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 14.4pt;"> <TD width="64" height="19" style="height: 14.4pt; width: 48pt;">OrderID</TD> <TD width="64" style="width: 48pt;">Customer</TD> <TD width="64" style="width: 48pt;">Gender</TD> </TR> <TR style="height: 14.4pt;"> <TD height="19" align="right" style="height: 14.4pt;">101</TD> <TD>A</TD> <TD>M</TD> </TR> <TR style="height: 14.4pt;"> <TD height="19" align="right" style="height: 14.4pt;">102</TD> <TD>A</TD> <TD>M</TD> </TR> <TR style="height: 14.4pt;"> <TD height="19" align="right" style="height: 14.4pt;">103</TD> <TD>B</TD> <TD>M</TD> </TR> <TR style="height: 14.4pt;"> <TD height="19" align="right" style="height: 14.4pt;">104</TD> <TD>B</TD> <TD>F</TD> </TR> </TBODY> </TABLE> Wed, 17 Jan 2024 12:55:40 GMT https://community.qlik.com/t5/App-Development/AGGR-Multiple-Dimensions/m-p/2162419#M94355 jono19872002 2024-01-17T12:55:40Z https://community.qlik.com/t5/App-Development/AGGR-Multiple-Dimensions/m-p/2162490#M94357 <P>Maybe in this simple way: applying Customer as dimension and count(distinct Gender)&gt;1 as expression.</P> Wed, 17 Jan 2024 15:25:09 GMT https://community.qlik.com/t5/App-Development/AGGR-Multiple-Dimensions/m-p/2162490#M94357 marcus_sommer 2024-01-17T15:25:09Z