topic Accumulation and removal of Blanks in App Development https://community.qlik.com/t5/App-Development/Accumulation-and-removal-of-Blanks/m-p/961317#M13768 <HTML><HEAD></HEAD><BODY><P><IMG alt="0802ffd5d83b4415bf5a565f5cd58406.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/101756_0802ffd5d83b4415bf5a565f5cd58406.png" style="height: 360px; width: 620px;" /></P><P>I have the above table I have used the following expression:</P><P></P><P>RangeSum(Before(Count([Days to pack back]),0,ColumnNo()))</P><P></P><P>What I need it to now is fill in all the blank rows where data could have been so like a </P><P></P><P>If(Column = - then match previous column) </P><P></P><P>However I want it to leave future dates as - </P><P></P><P>so It should look like it does on excel which is below </P><P></P><P>&nbsp; </P><TABLE border="1px" cellpadding="0" cellspacing="0" height="621" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;-webkit-right&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 732px; height: 531px; border-width: 1px; border-style: solid;"><TBODY><TR><TD class="xl63" height="20" width="70">Cumulative Weeks to Pack Back</TD><TD align="right" class="xl63" width="70">0</TD><TD align="right" class="xl63" width="70">1</TD><TD align="right" class="xl63" width="70">2</TD><TD align="right" class="xl63" width="70">3</TD><TD align="right" class="xl63" width="70">4</TD><TD align="right" class="xl63" width="70">5</TD><TD align="right" class="xl63" width="70">6</TD><TD align="right" class="xl63" width="70">7</TD><TD align="right" class="xl63" width="70">8</TD><TD align="right" class="xl63" width="70">9</TD><TD align="right" class="xl63" width="70">10</TD><TD align="right" class="xl63" width="70">17</TD></TR><TR><TD class="xl64" height="20">Week1</TD><TD align="right" class="xl65">0.00%</TD><TD align="right" class="xl65">50.51%</TD><TD align="right" class="xl65">61.62%</TD><TD align="right" class="xl65">65.66%</TD><TD align="right" class="xl65">66.67%</TD><TD align="right" class="xl65">66.67%</TD><TD align="right" class="xl65">69.70%</TD><TD align="right" class="xl65">69.70%</TD><TD align="right" class="xl65">70.71%</TD><TD align="right" class="xl65">70.71%</TD><TD align="right" class="xl65">70.71%</TD><TD align="right" class="xl65">70.71%</TD></TR><TR><TD class="xl64" height="20">Week2</TD><TD align="right" class="xl65">9.89%</TD><TD align="right" class="xl65">56.04%</TD><TD align="right" class="xl65">68.13%</TD><TD align="right" class="xl65">68.13%</TD><TD align="right" class="xl65">70.33%</TD><TD align="right" class="xl65">74.73%</TD><TD align="right" class="xl65">75.82%</TD><TD align="right" class="xl65">75.82%</TD><TD align="right" class="xl65">75.82%</TD><TD align="right" class="xl65">75.82%</TD><TD align="right" class="xl65">75.82%</TD><TD align="right" class="xl65">75.82%</TD></TR><TR><TD class="xl64" height="20">Week3</TD><TD align="right" class="xl65">1.89%</TD><TD align="right" class="xl65">41.51%</TD><TD align="right" class="xl65">50.94%</TD><TD align="right" class="xl65">56.60%</TD><TD align="right" class="xl65">64.15%</TD><TD align="right" class="xl65">64.15%</TD><TD align="right" class="xl65">66.04%</TD><TD align="right" class="xl65">67.92%</TD><TD align="right" class="xl65">67.92%</TD><TD align="right" class="xl65">67.92%</TD><TD align="right" class="xl65">67.92%</TD><TD align="right" class="xl65">67.92%</TD></TR><TR><TD class="xl64" height="20">Week4</TD><TD align="right" class="xl65">3.45%</TD><TD align="right" class="xl65">62.07%</TD><TD align="right" class="xl65">75.86%</TD><TD align="right" class="xl65">79.31%</TD><TD align="right" class="xl65">79.31%</TD><TD align="right" class="xl65">79.31%</TD><TD align="right" class="xl65">79.31%</TD><TD align="right" class="xl65">79.31%</TD><TD align="right" class="xl65">79.31%</TD><TD align="right" class="xl65">79.31%</TD><TD align="right" class="xl65">79.31%</TD><TD align="right" class="xl65">79.31%</TD></TR><TR><TD class="xl64" height="20">Week5</TD><TD align="right" class="xl65">12.50%</TD><TD align="right" class="xl65">58.33%</TD><TD align="right" class="xl65">58.33%</TD><TD align="right" class="xl65">62.50%</TD><TD align="right" class="xl65">66.67%</TD><TD align="right" class="xl65">66.67%</TD><TD align="right" class="xl65">70.83%</TD><TD align="right" class="xl65">70.83%</TD><TD align="right" class="xl65">70.83%</TD><TD align="right" class="xl65">70.83%</TD><TD align="right" class="xl65">70.83%</TD><TD align="right" class="xl65">70.83%</TD></TR><TR><TD class="xl64" height="20">Week6</TD><TD align="right" class="xl65">0.00%</TD><TD align="right" class="xl65">33.33%</TD><TD align="right" class="xl65">60.00%</TD><TD align="right" class="xl65">66.67%</TD><TD align="right" class="xl65">66.67%</TD><TD align="right" class="xl65">73.33%</TD><TD align="right" class="xl65">73.33%</TD><TD align="right" class="xl65">73.33%</TD><TD align="right" class="xl65">73.33%</TD><TD align="right" class="xl65">73.33%</TD><TD align="right" class="xl65">73.33%</TD><TD align="right" class="xl65">73.33%</TD></TR><TR><TD class="xl64" height="20">Week7</TD><TD align="right" class="xl65">7.69%</TD><TD align="right" class="xl65">69.23%</TD><TD align="right" class="xl65">76.92%</TD><TD align="right" class="xl65">80.77%</TD><TD align="right" class="xl65">84.62%</TD><TD align="right" class="xl65">84.62%</TD><TD align="right" class="xl65">88.46%</TD><TD align="right" class="xl65">88.46%</TD><TD align="right" class="xl65">88.46%</TD><TD align="right" class="xl65">88.46%</TD><TD align="right" class="xl65">88.46%</TD><TD align="right" class="xl65">88.46%</TD></TR><TR><TD class="xl64" height="20">Week8</TD><TD align="right" class="xl65">0.00%</TD><TD align="right" class="xl65">40.00%</TD><TD align="right" class="xl65">80.00%</TD><TD align="right" class="xl65">80.00%</TD><TD align="right" class="xl65">80.00%</TD><TD align="right" class="xl65">80.00%</TD><TD align="right" class="xl65">80.00%</TD><TD align="right" class="xl65">80.00%</TD><TD align="right" class="xl65">80.00%</TD><TD align="right" class="xl65">80.00%</TD><TD align="right" class="xl65">80.00%</TD><TD align="right" class="xl65">80.00%</TD></TR><TR><TD class="xl64" height="24">Week9</TD><TD align="right" class="xl65">0.00%</TD><TD align="right" class="xl65">66.67%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD></TR><TR><TD class="xl64" height="20">Week10</TD><TD align="right" class="xl65">0.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD></TR><TR><TD class="xl64" height="20">Week11</TD><TD align="right" class="xl65">0.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD></TR><TR><TD class="xl64" height="20">Week12</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD></TR><TR><TD class="xl64" height="20">Week13</TD><TD align="right" class="xl65">0.00%</TD><TD align="right" class="xl65">50.00%</TD><TD align="right" class="xl65">62.50%</TD><TD align="right" class="xl65">75.00%</TD><TD align="right" class="xl65">75.00%</TD><TD align="right" class="xl65">87.50%</TD><TD align="right" class="xl65">87.50%</TD><TD align="right" class="xl65">87.50%</TD><TD align="right" class="xl65">87.50%</TD><TD align="right" class="xl65">87.50%</TD><TD align="right" class="xl65">87.50%</TD><TD class="xl65"> </TD></TR><TR><TD class="xl64" height="20">Week14</TD><TD align="right" class="xl65">8.33%</TD><TD align="right" class="xl65">50.00%</TD><TD align="right" class="xl65">50.00%</TD><TD align="right" class="xl65">50.00%</TD><TD align="right" class="xl65">50.00%</TD><TD align="right" class="xl65">50.00%</TD><TD align="right" class="xl65">50.00%</TD><TD align="right" class="xl65">50.00%</TD><TD align="right" class="xl65">50.00%</TD><TD align="right" class="xl65">50.00%</TD><TD class="xl65"> </TD><TD class="xl65"> </TD></TR><TR><TD class="xl64" height="20">Week15</TD><TD align="right" class="xl65">20.00%</TD><TD align="right" class="xl65">60.00%</TD><TD align="right" class="xl65">60.00%</TD><TD align="right" class="xl65">60.00%</TD><TD align="right" class="xl65">60.00%</TD><TD align="right" class="xl65">60.00%</TD><TD align="right" class="xl65">60.00%</TD><TD align="right" class="xl65">60.00%</TD><TD align="right" class="xl65">60.00%</TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD></TR><TR><TD class="xl64" height="20">Week16</TD><TD align="right" class="xl65">0.00%</TD><TD align="right" class="xl65">69.23%</TD><TD align="right" class="xl65">69.23%</TD><TD align="right" class="xl65">69.23%</TD><TD align="right" class="xl65">69.23%</TD><TD align="right" class="xl65">69.23%</TD><TD align="right" class="xl65">69.23%</TD><TD align="right" class="xl65">69.23%</TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD></TR><TR><TD class="xl64" height="20">Week17</TD><TD align="right" class="xl65">0.00%</TD><TD align="right" class="xl65">0.00%</TD><TD align="right" class="xl65">0.00%</TD><TD align="right" class="xl65">0.00%</TD><TD align="right" class="xl65">0.00%</TD><TD align="right" class="xl65">0.00%</TD><TD align="right" class="xl65">0.00%</TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD></TR><TR><TD class="xl64" height="20">Week18</TD><TD align="right" class="xl65">0.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD></TR><TR><TD class="xl64" height="20">Week19</TD><TD align="right" class="xl65">0.00%</TD><TD align="right" class="xl65">40.00%</TD><TD align="right" class="xl65">60.00%</TD><TD align="right" class="xl65">60.00%</TD><TD align="right" class="xl65">60.00%</TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD></TR><TR><TD class="xl64" height="20">Week20</TD><TD align="right" class="xl65">2.27%</TD><TD align="right" class="xl65">52.27%</TD><TD align="right" class="xl65">61.36%</TD><TD align="right" class="xl65">70.45%</TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD></TR><TR><TD class="xl64" height="20">Week21</TD><TD align="right" class="xl65">3.13%</TD><TD align="right" class="xl65">53.13%</TD><TD align="right" class="xl65">62.50%</TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD></TR><TR><TD class="xl64" height="20">Week22</TD><TD align="right" class="xl65">9.30%</TD><TD align="right" class="xl65">53.49%</TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD></TR><TR><TD class="xl64" height="21">Week23</TD><TD align="right" class="xl65">0.00%</TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD></TR></TBODY></TABLE><P></P><P>How would I do this in an expression in Qlik Sense </P></BODY></HTML> Wed, 22 Dec 2021 20:40:09 GMT 2021-12-22T20:40:09Z Accumulation and removal of Blanks https://community.qlik.com/t5/App-Development/Accumulation-and-removal-of-Blanks/m-p/961317#M13768 <HTML><HEAD></HEAD><BODY><P><IMG alt="0802ffd5d83b4415bf5a565f5cd58406.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/101756_0802ffd5d83b4415bf5a565f5cd58406.png" style="height: 360px; width: 620px;" /></P><P>I have the above table I have used the following expression:</P><P></P><P>RangeSum(Before(Count([Days to pack back]),0,ColumnNo()))</P><P></P><P>What I need it to now is fill in all the blank rows where data could have been so like a </P><P></P><P>If(Column = - then match previous column) </P><P></P><P>However I want it to leave future dates as - </P><P></P><P>so It should look like it does on excel which is below </P><P></P><P>&nbsp; </P><TABLE border="1px" cellpadding="0" cellspacing="0" height="621" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;-webkit-right&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 732px; height: 531px; border-width: 1px; border-style: solid;"><TBODY><TR><TD class="xl63" height="20" width="70">Cumulative Weeks to Pack Back</TD><TD align="right" class="xl63" width="70">0</TD><TD align="right" class="xl63" width="70">1</TD><TD align="right" class="xl63" width="70">2</TD><TD align="right" class="xl63" width="70">3</TD><TD align="right" class="xl63" width="70">4</TD><TD align="right" class="xl63" width="70">5</TD><TD align="right" class="xl63" width="70">6</TD><TD align="right" class="xl63" width="70">7</TD><TD align="right" class="xl63" width="70">8</TD><TD align="right" class="xl63" width="70">9</TD><TD align="right" class="xl63" width="70">10</TD><TD align="right" class="xl63" width="70">17</TD></TR><TR><TD class="xl64" height="20">Week1</TD><TD align="right" class="xl65">0.00%</TD><TD align="right" class="xl65">50.51%</TD><TD align="right" class="xl65">61.62%</TD><TD align="right" class="xl65">65.66%</TD><TD align="right" class="xl65">66.67%</TD><TD align="right" class="xl65">66.67%</TD><TD align="right" class="xl65">69.70%</TD><TD align="right" class="xl65">69.70%</TD><TD align="right" class="xl65">70.71%</TD><TD align="right" class="xl65">70.71%</TD><TD align="right" class="xl65">70.71%</TD><TD align="right" class="xl65">70.71%</TD></TR><TR><TD class="xl64" height="20">Week2</TD><TD align="right" class="xl65">9.89%</TD><TD align="right" class="xl65">56.04%</TD><TD align="right" class="xl65">68.13%</TD><TD align="right" class="xl65">68.13%</TD><TD align="right" class="xl65">70.33%</TD><TD align="right" class="xl65">74.73%</TD><TD align="right" class="xl65">75.82%</TD><TD align="right" class="xl65">75.82%</TD><TD align="right" class="xl65">75.82%</TD><TD align="right" class="xl65">75.82%</TD><TD align="right" class="xl65">75.82%</TD><TD align="right" class="xl65">75.82%</TD></TR><TR><TD class="xl64" height="20">Week3</TD><TD align="right" class="xl65">1.89%</TD><TD align="right" class="xl65">41.51%</TD><TD align="right" class="xl65">50.94%</TD><TD align="right" class="xl65">56.60%</TD><TD align="right" class="xl65">64.15%</TD><TD align="right" class="xl65">64.15%</TD><TD align="right" class="xl65">66.04%</TD><TD align="right" class="xl65">67.92%</TD><TD align="right" class="xl65">67.92%</TD><TD align="right" class="xl65">67.92%</TD><TD align="right" class="xl65">67.92%</TD><TD align="right" class="xl65">67.92%</TD></TR><TR><TD class="xl64" height="20">Week4</TD><TD align="right" class="xl65">3.45%</TD><TD align="right" class="xl65">62.07%</TD><TD align="right" class="xl65">75.86%</TD><TD align="right" class="xl65">79.31%</TD><TD align="right" class="xl65">79.31%</TD><TD align="right" class="xl65">79.31%</TD><TD align="right" class="xl65">79.31%</TD><TD align="right" class="xl65">79.31%</TD><TD align="right" class="xl65">79.31%</TD><TD align="right" class="xl65">79.31%</TD><TD align="right" class="xl65">79.31%</TD><TD align="right" class="xl65">79.31%</TD></TR><TR><TD class="xl64" height="20">Week5</TD><TD align="right" class="xl65">12.50%</TD><TD align="right" class="xl65">58.33%</TD><TD align="right" class="xl65">58.33%</TD><TD align="right" class="xl65">62.50%</TD><TD align="right" class="xl65">66.67%</TD><TD align="right" class="xl65">66.67%</TD><TD align="right" class="xl65">70.83%</TD><TD align="right" class="xl65">70.83%</TD><TD align="right" class="xl65">70.83%</TD><TD align="right" class="xl65">70.83%</TD><TD align="right" class="xl65">70.83%</TD><TD align="right" class="xl65">70.83%</TD></TR><TR><TD class="xl64" height="20">Week6</TD><TD align="right" class="xl65">0.00%</TD><TD align="right" class="xl65">33.33%</TD><TD align="right" class="xl65">60.00%</TD><TD align="right" class="xl65">66.67%</TD><TD align="right" class="xl65">66.67%</TD><TD align="right" class="xl65">73.33%</TD><TD align="right" class="xl65">73.33%</TD><TD align="right" class="xl65">73.33%</TD><TD align="right" class="xl65">73.33%</TD><TD align="right" class="xl65">73.33%</TD><TD align="right" class="xl65">73.33%</TD><TD align="right" class="xl65">73.33%</TD></TR><TR><TD class="xl64" height="20">Week7</TD><TD align="right" class="xl65">7.69%</TD><TD align="right" class="xl65">69.23%</TD><TD align="right" class="xl65">76.92%</TD><TD align="right" class="xl65">80.77%</TD><TD align="right" class="xl65">84.62%</TD><TD align="right" class="xl65">84.62%</TD><TD align="right" class="xl65">88.46%</TD><TD align="right" class="xl65">88.46%</TD><TD align="right" class="xl65">88.46%</TD><TD align="right" class="xl65">88.46%</TD><TD align="right" class="xl65">88.46%</TD><TD align="right" class="xl65">88.46%</TD></TR><TR><TD class="xl64" height="20">Week8</TD><TD align="right" class="xl65">0.00%</TD><TD align="right" class="xl65">40.00%</TD><TD align="right" class="xl65">80.00%</TD><TD align="right" class="xl65">80.00%</TD><TD align="right" class="xl65">80.00%</TD><TD align="right" class="xl65">80.00%</TD><TD align="right" class="xl65">80.00%</TD><TD align="right" class="xl65">80.00%</TD><TD align="right" class="xl65">80.00%</TD><TD align="right" class="xl65">80.00%</TD><TD align="right" class="xl65">80.00%</TD><TD align="right" class="xl65">80.00%</TD></TR><TR><TD class="xl64" height="24">Week9</TD><TD align="right" class="xl65">0.00%</TD><TD align="right" class="xl65">66.67%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD></TR><TR><TD class="xl64" height="20">Week10</TD><TD align="right" class="xl65">0.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD></TR><TR><TD class="xl64" height="20">Week11</TD><TD align="right" class="xl65">0.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD></TR><TR><TD class="xl64" height="20">Week12</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD></TR><TR><TD class="xl64" height="20">Week13</TD><TD align="right" class="xl65">0.00%</TD><TD align="right" class="xl65">50.00%</TD><TD align="right" class="xl65">62.50%</TD><TD align="right" class="xl65">75.00%</TD><TD align="right" class="xl65">75.00%</TD><TD align="right" class="xl65">87.50%</TD><TD align="right" class="xl65">87.50%</TD><TD align="right" class="xl65">87.50%</TD><TD align="right" class="xl65">87.50%</TD><TD align="right" class="xl65">87.50%</TD><TD align="right" class="xl65">87.50%</TD><TD class="xl65"> </TD></TR><TR><TD class="xl64" height="20">Week14</TD><TD align="right" class="xl65">8.33%</TD><TD align="right" class="xl65">50.00%</TD><TD align="right" class="xl65">50.00%</TD><TD align="right" class="xl65">50.00%</TD><TD align="right" class="xl65">50.00%</TD><TD align="right" class="xl65">50.00%</TD><TD align="right" class="xl65">50.00%</TD><TD align="right" class="xl65">50.00%</TD><TD align="right" class="xl65">50.00%</TD><TD align="right" class="xl65">50.00%</TD><TD class="xl65"> </TD><TD class="xl65"> </TD></TR><TR><TD class="xl64" height="20">Week15</TD><TD align="right" class="xl65">20.00%</TD><TD align="right" class="xl65">60.00%</TD><TD align="right" class="xl65">60.00%</TD><TD align="right" class="xl65">60.00%</TD><TD align="right" class="xl65">60.00%</TD><TD align="right" class="xl65">60.00%</TD><TD align="right" class="xl65">60.00%</TD><TD align="right" class="xl65">60.00%</TD><TD align="right" class="xl65">60.00%</TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD></TR><TR><TD class="xl64" height="20">Week16</TD><TD align="right" class="xl65">0.00%</TD><TD align="right" class="xl65">69.23%</TD><TD align="right" class="xl65">69.23%</TD><TD align="right" class="xl65">69.23%</TD><TD align="right" class="xl65">69.23%</TD><TD align="right" class="xl65">69.23%</TD><TD align="right" class="xl65">69.23%</TD><TD align="right" class="xl65">69.23%</TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD></TR><TR><TD class="xl64" height="20">Week17</TD><TD align="right" class="xl65">0.00%</TD><TD align="right" class="xl65">0.00%</TD><TD align="right" class="xl65">0.00%</TD><TD align="right" class="xl65">0.00%</TD><TD align="right" class="xl65">0.00%</TD><TD align="right" class="xl65">0.00%</TD><TD align="right" class="xl65">0.00%</TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD></TR><TR><TD class="xl64" height="20">Week18</TD><TD align="right" class="xl65">0.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD align="right" class="xl65">100.00%</TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD></TR><TR><TD class="xl64" height="20">Week19</TD><TD align="right" class="xl65">0.00%</TD><TD align="right" class="xl65">40.00%</TD><TD align="right" class="xl65">60.00%</TD><TD align="right" class="xl65">60.00%</TD><TD align="right" class="xl65">60.00%</TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD></TR><TR><TD class="xl64" height="20">Week20</TD><TD align="right" class="xl65">2.27%</TD><TD align="right" class="xl65">52.27%</TD><TD align="right" class="xl65">61.36%</TD><TD align="right" class="xl65">70.45%</TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD></TR><TR><TD class="xl64" height="20">Week21</TD><TD align="right" class="xl65">3.13%</TD><TD align="right" class="xl65">53.13%</TD><TD align="right" class="xl65">62.50%</TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD></TR><TR><TD class="xl64" height="20">Week22</TD><TD align="right" class="xl65">9.30%</TD><TD align="right" class="xl65">53.49%</TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD></TR><TR><TD class="xl64" height="21">Week23</TD><TD align="right" class="xl65">0.00%</TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD><TD class="xl65"> </TD></TR></TBODY></TABLE><P></P><P>How would I do this in an expression in Qlik Sense </P></BODY></HTML> Wed, 22 Dec 2021 20:40:09 GMT https://community.qlik.com/t5/App-Development/Accumulation-and-removal-of-Blanks/m-p/961317#M13768 2021-12-22T20:40:09Z Re: Accumulation and removal of Blanks https://community.qlik.com/t5/App-Development/Accumulation-and-removal-of-Blanks/m-p/961318#M13769 <HTML><HEAD></HEAD><BODY><P>Could you post your app?</P></BODY></HTML> Mon, 12 Oct 2015 22:10:19 GMT https://community.qlik.com/t5/App-Development/Accumulation-and-removal-of-Blanks/m-p/961318#M13769 robert_mika 2015-10-12T22:10:19Z Re: Accumulation and removal of Blanks https://community.qlik.com/t5/App-Development/Accumulation-and-removal-of-Blanks/m-p/961319#M13770 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>Unfortunatly I cannot due to DPA ect I just need the add on to the Range sum Function complete development </P><P></P><P>Thanks for your reply </P></BODY></HTML> Tue, 13 Oct 2015 13:37:41 GMT https://community.qlik.com/t5/App-Development/Accumulation-and-removal-of-Blanks/m-p/961319#M13770 2015-10-13T13:37:41Z