https://community.qlik.com/t5/QlikView/SUM-data-on-3-WEEK/m-p/1817551#M1213133 <P>HI,</P><P>okay, I managed to come up with something like this, it's even cool, but you need to refine some ideas to improve it a little so that where there is zero, it does not enter the value in advance.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Luke_Killer_IT_0-1624523201916.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/57462i689F029A99D7DF41/image-size/medium?v=v2&amp;px=400" role="button" title="Luke_Killer_IT_0-1624523201916.png" alt="Luke_Killer_IT_0-1624523201916.png" /></span></P><P>&nbsp;</P> Thu, 24 Jun 2021 08:26:49 GMT Luke_Killer_IT 2021-06-24T08:26:49Z https://community.qlik.com/t5/QlikView/SUM-data-on-3-WEEK/m-p/1816038#M1213025 <P>Hi,&nbsp;</P><P>I would like to sum up the data from 3 weeks. I used such commands: sum ({&lt;KW = {'$ (= Max (KW))'}&gt;} MLA_MMT) but it does not work. HELP&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Luke_Killer_IT_0-1624010440763.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/57086i7125E975B0E01033/image-size/medium?v=v2&amp;px=400" role="button" title="Luke_Killer_IT_0-1624010440763.png" alt="Luke_Killer_IT_0-1624010440763.png" /></span></P><P>&nbsp;</P> Fri, 18 Jun 2021 10:03:53 GMT https://community.qlik.com/t5/QlikView/SUM-data-on-3-WEEK/m-p/1816038#M1213025 Luke_Killer_IT 2021-06-18T10:03:53Z https://community.qlik.com/t5/QlikView/SUM-data-on-3-WEEK/m-p/1816463#M1213051 <P>HI,</P><P>I have one more question whether it is possible to create a new column that groups my data as shown in the screen</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Luke_Killer_IT_0-1624263243260.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/57148iAC06E22FE676698B/image-size/medium?v=v2&amp;px=400" role="button" title="Luke_Killer_IT_0-1624263243260.png" alt="Luke_Killer_IT_0-1624263243260.png" /></span></P><P>&nbsp;</P> Mon, 21 Jun 2021 08:14:51 GMT https://community.qlik.com/t5/QlikView/SUM-data-on-3-WEEK/m-p/1816463#M1213051 Luke_Killer_IT 2021-06-21T08:14:51Z https://community.qlik.com/t5/QlikView/SUM-data-on-3-WEEK/m-p/1817551#M1213133 <P>HI,</P><P>okay, I managed to come up with something like this, it's even cool, but you need to refine some ideas to improve it a little so that where there is zero, it does not enter the value in advance.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Luke_Killer_IT_0-1624523201916.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/57462i689F029A99D7DF41/image-size/medium?v=v2&amp;px=400" role="button" title="Luke_Killer_IT_0-1624523201916.png" alt="Luke_Killer_IT_0-1624523201916.png" /></span></P><P>&nbsp;</P> Thu, 24 Jun 2021 08:26:49 GMT https://community.qlik.com/t5/QlikView/SUM-data-on-3-WEEK/m-p/1817551#M1213133 Luke_Killer_IT 2021-06-24T08:26:49Z