topic Weight expression in multidimensional pivot table in QlikView https://community.qlik.com/t5/QlikView/Weight-expression-in-multidimensional-pivot-table/m-p/370952#M493708 <HTML><HEAD></HEAD><BODY><P> I have a requirement to show weightage of Sales for each product within a Region/Country/State. In other words contribution of each product in Total sales for that dimension. In a straight table, it is very easy to this... by "selecting" the "Relative" checkbox for this expression.</P><P></P><P>But in a pivot table there is no "Relative" checkbox. As an alternative, in one of the discussions, it was mentioned to use the below</P><P></P><P><STRONG style="color: #3366ff;">Sales/Sum(Total Sales) </STRONG>... this works for a single dimensional pivot table. But in multidimensional pivot, the <STRONG style="color: #0000ff;">Sum(TOTAL Sales)</STRONG> actually aggregates the total sum of <SPAN style="color: #3366ff;"><EM>all products across regions, states</EM></SPAN>. </P><P></P><P>I created a test document for the same. Someone kindly help me fix this.</P></BODY></HTML> Thu, 26 Apr 2012 19:15:11 GMT manoranjan 2012-04-26T19:15:11Z Weight expression in multidimensional pivot table https://community.qlik.com/t5/QlikView/Weight-expression-in-multidimensional-pivot-table/m-p/370952#M493708 <HTML><HEAD></HEAD><BODY><P> I have a requirement to show weightage of Sales for each product within a Region/Country/State. In other words contribution of each product in Total sales for that dimension. In a straight table, it is very easy to this... by "selecting" the "Relative" checkbox for this expression.</P><P></P><P>But in a pivot table there is no "Relative" checkbox. As an alternative, in one of the discussions, it was mentioned to use the below</P><P></P><P><STRONG style="color: #3366ff;">Sales/Sum(Total Sales) </STRONG>... this works for a single dimensional pivot table. But in multidimensional pivot, the <STRONG style="color: #0000ff;">Sum(TOTAL Sales)</STRONG> actually aggregates the total sum of <SPAN style="color: #3366ff;"><EM>all products across regions, states</EM></SPAN>. </P><P></P><P>I created a test document for the same. Someone kindly help me fix this.</P></BODY></HTML> Thu, 26 Apr 2012 19:15:11 GMT https://community.qlik.com/t5/QlikView/Weight-expression-in-multidimensional-pivot-table/m-p/370952#M493708 manoranjan 2012-04-26T19:15:11Z Weight expression in multidimensional pivot table https://community.qlik.com/t5/QlikView/Weight-expression-in-multidimensional-pivot-table/m-p/370953#M493709 <HTML><HEAD></HEAD><BODY><P>You can actually use a field list with TOTAL qualifier, so try:</P><P></P><P>sum(Sales)/sum( <STRONG>total&lt;Product&gt;</STRONG> Sales)</P></BODY></HTML> Thu, 26 Apr 2012 21:46:32 GMT https://community.qlik.com/t5/QlikView/Weight-expression-in-multidimensional-pivot-table/m-p/370953#M493709 swuehl 2012-04-26T21:46:32Z Weight expression in multidimensional pivot table https://community.qlik.com/t5/QlikView/Weight-expression-in-multidimensional-pivot-table/m-p/370954#M493710 <HTML><HEAD></HEAD><BODY><P> Thanks swuehl, I guess thats exactly what I want. Will try in the main dashboard now. </P></BODY></HTML> Fri, 27 Apr 2012 05:05:54 GMT https://community.qlik.com/t5/QlikView/Weight-expression-in-multidimensional-pivot-table/m-p/370954#M493710 manoranjan 2012-04-27T05:05:54Z