topic Aggregation with Linked table and Dynamic Dimensions in QlikView https://community.qlik.com/t5/QlikView/Aggregation-with-Linked-table-and-Dynamic-Dimensions/m-p/245857#M1185222 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I would like to sum the 'cost' by a dimension(Exam) however the 'cost' is in a linked table and it only brings back the cost of one exam. For example in my main table there are two exams of type 'a'. The cost for a Type 'a' exam is £50. I would want the expression to show £100 however it is only coming back with £50. </P><P></P><P>Using AGGR I have come up with something that seems to work but wanted to check a) is there a better way and b) what happens when i would like to use a cyclic dimension</P><P></P><P>I have attached a basic example.</P><P></P><P>Kind regards,</P><P></P><P>Dan</P></BODY></HTML> Thu, 13 Oct 2011 10:04:12 GMT 2011-10-13T10:04:12Z Aggregation with Linked table and Dynamic Dimensions https://community.qlik.com/t5/QlikView/Aggregation-with-Linked-table-and-Dynamic-Dimensions/m-p/245857#M1185222 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I would like to sum the 'cost' by a dimension(Exam) however the 'cost' is in a linked table and it only brings back the cost of one exam. For example in my main table there are two exams of type 'a'. The cost for a Type 'a' exam is £50. I would want the expression to show £100 however it is only coming back with £50. </P><P></P><P>Using AGGR I have come up with something that seems to work but wanted to check a) is there a better way and b) what happens when i would like to use a cyclic dimension</P><P></P><P>I have attached a basic example.</P><P></P><P>Kind regards,</P><P></P><P>Dan</P></BODY></HTML> Thu, 13 Oct 2011 10:04:12 GMT https://community.qlik.com/t5/QlikView/Aggregation-with-Linked-table-and-Dynamic-Dimensions/m-p/245857#M1185222 2011-10-13T10:04:12Z Re: Aggregation with Linked table and Dynamic Dimensions https://community.qlik.com/t5/QlikView/Aggregation-with-Linked-table-and-Dynamic-Dimensions/m-p/245858#M1185223 <HTML><HEAD></HEAD><BODY><P>i have attached qvw, check in the expression int this,might be it helps you.</P></BODY></HTML> Thu, 13 Oct 2011 11:25:45 GMT https://community.qlik.com/t5/QlikView/Aggregation-with-Linked-table-and-Dynamic-Dimensions/m-p/245858#M1185223 2011-10-13T11:25:45Z