topic Partial sum in row in QlikView

topic Partial sum in row in QlikView https://community.qlik.com/t5/QlikView/Partial-sum-in-row/m-p/24594#M4055 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I want to display the Perc% column in Qlikview. </P><P>    </P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{"color":"#575757","textAlign":"left","padding":"NaN","backgroundColor":"transparent","fontFamily":"arial,helvetica,sans-serif","verticalAlign":"baseline"}" jive-data-header="{"color":"#FFFFFF","backgroundColor":"#6690BC","textAlign":"center","padding":"2"}" style="width: 435px;"><TBODY><TR><TD class="xl67" height="17" width="98">Week</TD><TD class="xl67" style="border-left: none;" width="98">WeekDay</TD><TD class="xl68" style="border-left: none;" width="98">Sales</TD><TD class="xl68" style="border-left: none;" width="77">Total</TD><TD class="xl69" style="border-left: none;" width="64">Perc%</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">W1</TD><TD class="xl70" style="border-top: none; border-left: none;">Fri</TD><TD class="xl70" style="border-top: none; border-left: none;">5</TD><TD class="xl71" style="border-top: none; border-left: none;">28</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">18%</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">W1</TD><TD class="xl70" style="border-top: none; border-left: none;">Mon</TD><TD class="xl70" style="border-top: none; border-left: none;">1</TD><TD class="xl71" style="border-top: none; border-left: none;">28</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">4%</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">W1</TD><TD class="xl70" style="border-top: none; border-left: none;">Sat</TD><TD class="xl70" style="border-top: none; border-left: none;">6</TD><TD class="xl71" style="border-top: none; border-left: none;">28</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">21%</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">W1</TD><TD class="xl70" style="border-top: none; border-left: none;">Sun</TD><TD class="xl70" style="border-top: none; border-left: none;">7</TD><TD class="xl71" style="border-top: none; border-left: none;">28</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">25%</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">W1</TD><TD class="xl70" style="border-top: none; border-left: none;">Thu</TD><TD class="xl70" style="border-top: none; border-left: none;">4</TD><TD class="xl71" style="border-top: none; border-left: none;">28</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">14%</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">W1</TD><TD class="xl70" style="border-top: none; border-left: none;">Tue</TD><TD class="xl70" style="border-top: none; border-left: none;">2</TD><TD class="xl71" style="border-top: none; border-left: none;">28</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">7%</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">W1</TD><TD class="xl70" style="border-top: none; border-left: none;">Wed</TD><TD class="xl70" style="border-top: none; border-left: none;">3</TD><TD class="xl71" style="border-top: none; border-left: none;">28</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">11%</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">W1</TD><TD class="xl71" style="border-top: none; border-left: none;">Total</TD><TD class="xl71" style="border-top: none; border-left: none;">28</TD><TD class="xl71" style="border-top: none; border-left: none;">28</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">100%</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">W2</TD><TD class="xl70" style="border-top: none; border-left: none;">Fri</TD><TD class="xl70" style="border-top: none; border-left: none;">12</TD><TD class="xl71" style="border-top: none; border-left: none;">77</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">16%</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">W2</TD><TD class="xl70" style="border-top: none; border-left: none;">Mon</TD><TD class="xl70" style="border-top: none; border-left: none;">8</TD><TD class="xl71" style="border-top: none; border-left: none;">77</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">10%</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">W2</TD><TD class="xl70" style="border-top: none; border-left: none;">Sat</TD><TD class="xl70" style="border-top: none; border-left: none;">13</TD><TD class="xl71" style="border-top: none; border-left: none;">77</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">17%</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">W2</TD><TD class="xl70" style="border-top: none; border-left: none;">Sun</TD><TD class="xl70" style="border-top: none; border-left: none;">14</TD><TD class="xl71" style="border-top: none; border-left: none;">77</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">18%</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">W2</TD><TD class="xl70" style="border-top: none; border-left: none;">Thu</TD><TD class="xl70" style="border-top: none; border-left: none;">11</TD><TD class="xl71" style="border-top: none; border-left: none;">77</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">14%</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">W2</TD><TD class="xl70" style="border-top: none; border-left: none;">Tue</TD><TD class="xl70" style="border-top: none; border-left: none;">9</TD><TD class="xl71" style="border-top: none; border-left: none;">77</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">12%</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">W2</TD><TD class="xl70" style="border-top: none; border-left: none;">Wed</TD><TD class="xl70" style="border-top: none; border-left: none;">10</TD><TD class="xl71" style="border-top: none; border-left: none;">77</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">13%</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">W2</TD><TD class="xl71" style="border-top: none; border-left: none;">Total</TD><TD class="xl71" style="border-top: none; border-left: none;">77</TD><TD class="xl71" style="border-top: none; border-left: none;">77</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">100%</TD></TR><TR><TD class="xl71" height="17" style="border-top: none;">Total</TD><TD class="xl71" style="border-top: none; border-left: none;"> </TD><TD class="xl71" style="border-top: none; border-left: none;">105</TD><TD class="xl71" style="border-top: none; border-left: none;"> </TD><TD class="xl72" style="border-top: none; border-left: none;"> </TD></TR></TBODY></TABLE></BODY></HTML> Tue, 30 Jan 2018 18:37:03 GMT Anonymous 2018-01-30T18:37:03Z Partial sum in row https://community.qlik.com/t5/QlikView/Partial-sum-in-row/m-p/24594#M4055 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I want to display the Perc% column in Qlikview. </P><P>    </P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{"color":"#575757","textAlign":"left","padding":"NaN","backgroundColor":"transparent","fontFamily":"arial,helvetica,sans-serif","verticalAlign":"baseline"}" jive-data-header="{"color":"#FFFFFF","backgroundColor":"#6690BC","textAlign":"center","padding":"2"}" style="width: 435px;"><TBODY><TR><TD class="xl67" height="17" width="98">Week</TD><TD class="xl67" style="border-left: none;" width="98">WeekDay</TD><TD class="xl68" style="border-left: none;" width="98">Sales</TD><TD class="xl68" style="border-left: none;" width="77">Total</TD><TD class="xl69" style="border-left: none;" width="64">Perc%</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">W1</TD><TD class="xl70" style="border-top: none; border-left: none;">Fri</TD><TD class="xl70" style="border-top: none; border-left: none;">5</TD><TD class="xl71" style="border-top: none; border-left: none;">28</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">18%</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">W1</TD><TD class="xl70" style="border-top: none; border-left: none;">Mon</TD><TD class="xl70" style="border-top: none; border-left: none;">1</TD><TD class="xl71" style="border-top: none; border-left: none;">28</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">4%</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">W1</TD><TD class="xl70" style="border-top: none; border-left: none;">Sat</TD><TD class="xl70" style="border-top: none; border-left: none;">6</TD><TD class="xl71" style="border-top: none; border-left: none;">28</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">21%</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">W1</TD><TD class="xl70" style="border-top: none; border-left: none;">Sun</TD><TD class="xl70" style="border-top: none; border-left: none;">7</TD><TD class="xl71" style="border-top: none; border-left: none;">28</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">25%</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">W1</TD><TD class="xl70" style="border-top: none; border-left: none;">Thu</TD><TD class="xl70" style="border-top: none; border-left: none;">4</TD><TD class="xl71" style="border-top: none; border-left: none;">28</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">14%</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">W1</TD><TD class="xl70" style="border-top: none; border-left: none;">Tue</TD><TD class="xl70" style="border-top: none; border-left: none;">2</TD><TD class="xl71" style="border-top: none; border-left: none;">28</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">7%</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">W1</TD><TD class="xl70" style="border-top: none; border-left: none;">Wed</TD><TD class="xl70" style="border-top: none; border-left: none;">3</TD><TD class="xl71" style="border-top: none; border-left: none;">28</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">11%</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">W1</TD><TD class="xl71" style="border-top: none; border-left: none;">Total</TD><TD class="xl71" style="border-top: none; border-left: none;">28</TD><TD class="xl71" style="border-top: none; border-left: none;">28</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">100%</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">W2</TD><TD class="xl70" style="border-top: none; border-left: none;">Fri</TD><TD class="xl70" style="border-top: none; border-left: none;">12</TD><TD class="xl71" style="border-top: none; border-left: none;">77</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">16%</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">W2</TD><TD class="xl70" style="border-top: none; border-left: none;">Mon</TD><TD class="xl70" style="border-top: none; border-left: none;">8</TD><TD class="xl71" style="border-top: none; border-left: none;">77</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">10%</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">W2</TD><TD class="xl70" style="border-top: none; border-left: none;">Sat</TD><TD class="xl70" style="border-top: none; border-left: none;">13</TD><TD class="xl71" style="border-top: none; border-left: none;">77</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">17%</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">W2</TD><TD class="xl70" style="border-top: none; border-left: none;">Sun</TD><TD class="xl70" style="border-top: none; border-left: none;">14</TD><TD class="xl71" style="border-top: none; border-left: none;">77</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">18%</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">W2</TD><TD class="xl70" style="border-top: none; border-left: none;">Thu</TD><TD class="xl70" style="border-top: none; border-left: none;">11</TD><TD class="xl71" style="border-top: none; border-left: none;">77</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">14%</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">W2</TD><TD class="xl70" style="border-top: none; border-left: none;">Tue</TD><TD class="xl70" style="border-top: none; border-left: none;">9</TD><TD class="xl71" style="border-top: none; border-left: none;">77</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">12%</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">W2</TD><TD class="xl70" style="border-top: none; border-left: none;">Wed</TD><TD class="xl70" style="border-top: none; border-left: none;">10</TD><TD class="xl71" style="border-top: none; border-left: none;">77</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">13%</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">W2</TD><TD class="xl71" style="border-top: none; border-left: none;">Total</TD><TD class="xl71" style="border-top: none; border-left: none;">77</TD><TD class="xl71" style="border-top: none; border-left: none;">77</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">100%</TD></TR><TR><TD class="xl71" height="17" style="border-top: none;">Total</TD><TD class="xl71" style="border-top: none; border-left: none;"> </TD><TD class="xl71" style="border-top: none; border-left: none;">105</TD><TD class="xl71" style="border-top: none; border-left: none;"> </TD><TD class="xl72" style="border-top: none; border-left: none;"> </TD></TR></TBODY></TABLE></BODY></HTML> Tue, 30 Jan 2018 18:37:03 GMT https://community.qlik.com/t5/QlikView/Partial-sum-in-row/m-p/24594#M4055 Anonymous 2018-01-30T18:37:03Z Re: Partial sum in row https://community.qlik.com/t5/QlikView/Partial-sum-in-row/m-p/24595#M4056 <HTML><HEAD></HEAD><BODY><P>Check attached</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/191917_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 30 Jan 2018 19:31:57 GMT https://community.qlik.com/t5/QlikView/Partial-sum-in-row/m-p/24595#M4056 sunny_talwar 2018-01-30T19:31:57Z Re: Partial sum in row https://community.qlik.com/t5/QlikView/Partial-sum-in-row/m-p/24596#M4057 <HTML><HEAD></HEAD><BODY><P>Thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 31 Jan 2018 05:22:56 GMT https://community.qlik.com/t5/QlikView/Partial-sum-in-row/m-p/24596#M4057 Anonymous 2018-01-31T05:22:56Z