topic Dimension total in QlikView https://community.qlik.com/t5/QlikView/Dimension-total/m-p/940831#M324477 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>as per attached image ,I have two dimensions(Product,Units) and two facts(revenue,cost) in a Straight table.</P><P></P><P>I want to see totals for units(dimension) on the top of this column.</P><P></P><P>kindly provide me expression for total of dimension(units) on top of this column</P></BODY></HTML> Thu, 08 Oct 2015 16:35:24 GMT srinivas1921 2015-10-08T16:35:24Z Dimension total https://community.qlik.com/t5/QlikView/Dimension-total/m-p/940831#M324477 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>as per attached image ,I have two dimensions(Product,Units) and two facts(revenue,cost) in a Straight table.</P><P></P><P>I want to see totals for units(dimension) on the top of this column.</P><P></P><P>kindly provide me expression for total of dimension(units) on top of this column</P></BODY></HTML> Thu, 08 Oct 2015 16:35:24 GMT https://community.qlik.com/t5/QlikView/Dimension-total/m-p/940831#M324477 srinivas1921 2015-10-08T16:35:24Z Re: Dimension total https://community.qlik.com/t5/QlikView/Dimension-total/m-p/940832#M324478 <HTML><HEAD></HEAD><BODY><P>I agree with maxgro - since you are counting units over product, units does not need to be a dimesnion and the qvw Krishna sent to show totals should provide you with the solution to your issue - if it does not please let us know</P></BODY></HTML> Thu, 08 Oct 2015 16:39:30 GMT https://community.qlik.com/t5/QlikView/Dimension-total/m-p/940832#M324478 2015-10-08T16:39:30Z Re: Dimension total https://community.qlik.com/t5/QlikView/Dimension-total/m-p/940833#M324479 <HTML><HEAD></HEAD><BODY><P>See attached and follow as is.</P><P></P><P><IMG alt="Capture1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/101462_Capture1.PNG" style="height: auto;" /></P><P></P><P>Thanks</P></BODY></HTML> Thu, 08 Oct 2015 16:41:33 GMT https://community.qlik.com/t5/QlikView/Dimension-total/m-p/940833#M324479 Qrishna 2015-10-08T16:41:33Z Re: Dimension total https://community.qlik.com/t5/QlikView/Dimension-total/m-p/940834#M324480 <HTML><HEAD></HEAD><BODY><P>Is there a reason to have units as dimension and not as measure (and use the expression total to get the total as in your image)?</P></BODY></HTML> Thu, 08 Oct 2015 17:08:21 GMT https://community.qlik.com/t5/QlikView/Dimension-total/m-p/940834#M324480 maxgro 2015-10-08T17:08:21Z Re: Dimension total https://community.qlik.com/t5/QlikView/Dimension-total/m-p/940835#M324481 <HTML><HEAD></HEAD><BODY><P>Any Luck?</P></BODY></HTML> Mon, 12 Oct 2015 13:14:18 GMT https://community.qlik.com/t5/QlikView/Dimension-total/m-p/940835#M324481 Qrishna 2015-10-12T13:14:18Z