topic Re: Sum by Dimension Issue in QlikView https://community.qlik.com/t5/QlikView/Sum-by-Dimension-Issue/m-p/576028#M683490 <HTML><HEAD></HEAD><BODY><P>Can you share the App or maybe the Expression</P></BODY></HTML> Fri, 14 Mar 2014 11:00:58 GMT rustyfishbones 2014-03-14T11:00:58Z Sum by Dimension Issue https://community.qlik.com/t5/QlikView/Sum-by-Dimension-Issue/m-p/576027#M683489 <HTML><HEAD></HEAD><BODY><P>morning,</P><P></P><P>having a nightmare this morning with a really simple problem.</P><P></P><P>using an SAP schema, so all based around start and end dates.</P><P></P><P>i have a straight table, with Age_Band as the dimension. The expression is built up of a concatenation of Day, Month and Year with a set expression to count the unique staff id's</P><P></P><P>the total number calculated is correct, only instead of splitting up the value by the dimension i get the same top level value for each row in the dimension. Ie</P><P></P><TABLE border="1" class="jiveBorder" height="100" style="border: 1px solid rgb(0, 0, 0); width: 186px; height: 83px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Age</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Headcount</STRONG><BR /><BR /></TH></TR><TR><TD style="padding: 2px;">20</TD><TD style="padding: 2px;">1000</TD></TR><TR><TD style="padding: 2px;">25</TD><TD style="padding: 2px;">1000</TD></TR></TBODY></TABLE><P></P><P>in the above example 1000 is the sum total, not the values for 20 and 25. i'm doing something stupid im sure.</P><P></P><P>losing my mind!</P></BODY></HTML> Fri, 14 Mar 2014 10:58:32 GMT https://community.qlik.com/t5/QlikView/Sum-by-Dimension-Issue/m-p/576027#M683489 wonkymeister 2014-03-14T10:58:32Z Re: Sum by Dimension Issue https://community.qlik.com/t5/QlikView/Sum-by-Dimension-Issue/m-p/576028#M683490 <HTML><HEAD></HEAD><BODY><P>Can you share the App or maybe the Expression</P></BODY></HTML> Fri, 14 Mar 2014 11:00:58 GMT https://community.qlik.com/t5/QlikView/Sum-by-Dimension-Issue/m-p/576028#M683490 rustyfishbones 2014-03-14T11:00:58Z Re: Sum by Dimension Issue https://community.qlik.com/t5/QlikView/Sum-by-Dimension-Issue/m-p/576029#M683491 <HTML><HEAD></HEAD><BODY><P>May be you need to use Aggr function.</P><P>Better is you share sample data or apps !</P></BODY></HTML> Fri, 14 Mar 2014 11:03:12 GMT https://community.qlik.com/t5/QlikView/Sum-by-Dimension-Issue/m-p/576029#M683491 MK_QSL 2014-03-14T11:03:12Z Re: Sum by Dimension Issue https://community.qlik.com/t5/QlikView/Sum-by-Dimension-Issue/m-p/576030#M683492 <HTML><HEAD></HEAD><BODY><P>Use distinct Qualifier.</P><P></P><P>Please share your qvw.</P></BODY></HTML> Sat, 15 Mar 2014 01:49:05 GMT https://community.qlik.com/t5/QlikView/Sum-by-Dimension-Issue/m-p/576030#M683492 2014-03-15T01:49:05Z