topic expression sum over one dimension only in QlikView https://community.qlik.com/t5/QlikView/expression-sum-over-one-dimension-only/m-p/389686#M571303 <HTML><HEAD></HEAD><BODY><P>Good morning</P><P>I have a pivot (or straight table) table with 2 dimensions, and 1 expression as in the attached example (Count(MVCDE)*MZPRT). I need to compare the expression total over dimension DESTINAZIONE to the original expression.</P><P></P><P>This should be somehow straight forward, but I am unable to get it right. So I need a new column in QV as column F in the attached excel.</P><P></P><P>Any ideas?</P><P>Thank you</P></BODY></HTML> Mon, 10 Sep 2012 07:23:59 GMT giakoum 2012-09-10T07:23:59Z expression sum over one dimension only https://community.qlik.com/t5/QlikView/expression-sum-over-one-dimension-only/m-p/389686#M571303 <HTML><HEAD></HEAD><BODY><P>Good morning</P><P>I have a pivot (or straight table) table with 2 dimensions, and 1 expression as in the attached example (Count(MVCDE)*MZPRT). I need to compare the expression total over dimension DESTINAZIONE to the original expression.</P><P></P><P>This should be somehow straight forward, but I am unable to get it right. So I need a new column in QV as column F in the attached excel.</P><P></P><P>Any ideas?</P><P>Thank you</P></BODY></HTML> Mon, 10 Sep 2012 07:23:59 GMT https://community.qlik.com/t5/QlikView/expression-sum-over-one-dimension-only/m-p/389686#M571303 giakoum 2012-09-10T07:23:59Z Re: expression sum over one dimension only https://community.qlik.com/t5/QlikView/expression-sum-over-one-dimension-only/m-p/389687#M571304 <HTML><HEAD></HEAD><BODY><P>This gives what you want:</P><P>=Sum(total&lt;DESTINAZIONE&gt; aggr(distinct Count(MVCDE)*MZPRT, DESTINAZIONE, MEZZO))</P></BODY></HTML> Mon, 10 Sep 2012 08:15:47 GMT https://community.qlik.com/t5/QlikView/expression-sum-over-one-dimension-only/m-p/389687#M571304 whiteline 2012-09-10T08:15:47Z Re: expression sum over one dimension only https://community.qlik.com/t5/QlikView/expression-sum-over-one-dimension-only/m-p/389688#M571305 <HTML><HEAD></HEAD><BODY><P>thank you!</P></BODY></HTML> Mon, 10 Sep 2012 09:05:19 GMT https://community.qlik.com/t5/QlikView/expression-sum-over-one-dimension-only/m-p/389688#M571305 giakoum 2012-09-10T09:05:19Z