topic Re: % of Row Total in QlikView https://community.qlik.com/t5/QlikView/of-Row-Total/m-p/121205#M761332 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Can You Try This May Work </P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Sum(Measure)/Sum(TOTAL &lt;MonthField&gt; Measure)</STRONG></P></BODY></HTML> Thu, 09 Aug 2018 03:02:24 GMT sujan24s 2018-08-09T03:02:24Z % of Row Total https://community.qlik.com/t5/QlikView/of-Row-Total/m-p/121203#M761330 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">I need to find the percent of row total for a pivot table...</P><P style="font-size: 13.3333px;">my table looks like this</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"><SPAN style="text-decoration: underline;">Year</SPAN> <SPAN style="text-decoration: underline;">Month</SPAN> <SPAN style="text-decoration: underline;">Place</SPAN>&nbsp;&nbsp;&nbsp;&nbsp; Home&nbsp;&nbsp;&nbsp;&nbsp; Work&nbsp;&nbsp;&nbsp;&nbsp; School&nbsp;&nbsp;&nbsp;&nbsp; Total</P><P style="font-size: 13.3333px;">1&nbsp;&nbsp;&nbsp;&nbsp; Jan&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; %&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; %&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; %&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100%</P><P style="font-size: 13.3333px;">2&nbsp;&nbsp;&nbsp;&nbsp; Feb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; %&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; %&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; %&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100%</P><P style="font-size: 13.3333px;">3&nbsp;&nbsp;&nbsp;&nbsp; Mar&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; %&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; %&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; %&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100%</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">My dimensions are Year, Month, and Place and my expression should be the %..</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Can anyone help with this?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/of-Row-Total/m-p/121203#M761330 kaylaramsey2 2020-11-25T16:16:04Z Re: % of Row Total https://community.qlik.com/t5/QlikView/of-Row-Total/m-p/121204#M761331 <HTML><HEAD></HEAD><BODY><P>Not sure, What your intend? Can you explain little more using data set.</P></BODY></HTML> Thu, 09 Aug 2018 00:04:12 GMT https://community.qlik.com/t5/QlikView/of-Row-Total/m-p/121204#M761331 Anil_Babu_Samineni 2018-08-09T00:04:12Z Re: % of Row Total https://community.qlik.com/t5/QlikView/of-Row-Total/m-p/121205#M761332 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Can You Try This May Work </P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Sum(Measure)/Sum(TOTAL &lt;MonthField&gt; Measure)</STRONG></P></BODY></HTML> Thu, 09 Aug 2018 03:02:24 GMT https://community.qlik.com/t5/QlikView/of-Row-Total/m-p/121205#M761332 sujan24s 2018-08-09T03:02:24Z Re: % of Row Total https://community.qlik.com/t5/QlikView/of-Row-Total/m-p/121206#M761333 <HTML><HEAD></HEAD><BODY><P>or this </P><P></P><P><STRONG>Sum(Measure)/Sum(TOTAL &lt;Year, Month&gt; Measure)</STRONG></P></BODY></HTML> Thu, 09 Aug 2018 10:44:05 GMT https://community.qlik.com/t5/QlikView/of-Row-Total/m-p/121206#M761333 sunny_talwar 2018-08-09T10:44:05Z