topic Help with Summary Expression in QlikView https://community.qlik.com/t5/QlikView/Help-with-Summary-Expression/m-p/192240#M53981 <HTML><HEAD></HEAD><BODY><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">sum({&lt;ItemCode={"=count(ItemCode)&gt;1"}&gt;}Value)</PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Sat, 19 Sep 2009 23:24:35 GMT 2009-09-19T23:24:35Z Help with Summary Expression https://community.qlik.com/t5/QlikView/Help-with-Summary-Expression/m-p/192239#M53980 <HTML><HEAD></HEAD><BODY><P></P><DIV style="background-color: #ffffff; margin: 8px; font-family: Arial, Helvetica, sans-serif; color: #000000; font-size: 12px; -webkit-background-clip: initial; -webkit-background-origin: initial;"><P>Can you guys please help with this summary expression. I'm completely stuck.</P><P>I have a table that has 3 columns - ItemCode, Ownership, Value. An ItemCode can have one ownership or multiple ownerships. I need to create a bar chart with Ownership as the dimension and the total Value of all ItemCodes <U class="Apple-style-span" style="text-decoration: underline;">that have more than one ownership</U> as the expression.</P><P>Here is what I did -</P><P>Dimension is just the Ownership column</P><P>Expression is...</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">sum(aggr(If(Count(distinct [Ownership])&gt;1, sum(Value),0.00),ItemCode))</PRE><BR /><BR /> <P>This expression is unable to break apart the Value for each ownership dimension</P><P>Any suggestions will be greatly appreciated. I'm attaching the QVD for your reference.</P></DIV><BR /><BR /></BODY></HTML> Sat, 19 Sep 2009 05:19:55 GMT https://community.qlik.com/t5/QlikView/Help-with-Summary-Expression/m-p/192239#M53980 2009-09-19T05:19:55Z Help with Summary Expression https://community.qlik.com/t5/QlikView/Help-with-Summary-Expression/m-p/192240#M53981 <HTML><HEAD></HEAD><BODY><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">sum({&lt;ItemCode={"=count(ItemCode)&gt;1"}&gt;}Value)</PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Sat, 19 Sep 2009 23:24:35 GMT https://community.qlik.com/t5/QlikView/Help-with-Summary-Expression/m-p/192240#M53981 2009-09-19T23:24:35Z Help with Summary Expression https://community.qlik.com/t5/QlikView/Help-with-Summary-Expression/m-p/192241#M53982 <HTML><HEAD></HEAD><BODY><P>Thanks very much Richy...This is exactly what I was looking for...Thanks again!</P></BODY></HTML> Mon, 21 Sep 2009 19:15:44 GMT https://community.qlik.com/t5/QlikView/Help-with-Summary-Expression/m-p/192241#M53982 2009-09-21T19:15:44Z