https://community.qlik.com/t5/QlikView/Calculate-last-4-months-in-each-row/m-p/1815970#M1213020 <P>I just want to Calculate last 4 months in each row in Straight table , this is my first time to use QlikView Please help me</P><P>&nbsp;My Sample Data.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JoshLeslie_07_0-1623981328878.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/57062iA2CDFB2F5B98C47A/image-size/medium?v=v2&amp;px=400" role="button" title="JoshLeslie_07_0-1623981328878.png" alt="JoshLeslie_07_0-1623981328878.png" /></span></P><P>here is exactly what I want.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="testimage.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/57063iDB929E08E6A6D94A/image-size/medium?v=v2&amp;px=400" role="button" title="testimage.png" alt="testimage.png" /></span></P><P>but my output is wrong&nbsp; screenshot below.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JoshLeslie_07_1-1623981611191.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/57064i0A3F8457CEDC6534/image-size/medium?v=v2&amp;px=400" role="button" title="JoshLeslie_07_1-1623981611191.png" alt="JoshLeslie_07_1-1623981611191.png" /></span></P><P>&nbsp;</P><P>My Expression that I used so far , it's same result.</P><P>Max( aggr( rangesum( below( sum(Sales),0,4) ),Month))</P><P>Max(Aggr(RangeSum(Below(Sum({&lt;Month, [MonthYear], MonthYear, Year&gt;}Sales), 0, 4)), [MonthYear]))</P><P>Max( aggr( rangesum( below( sum( {$&lt;MonthYear&gt;} Sales),0,4) ),MonthYear))</P> Fri, 18 Jun 2021 02:02:27 GMT JoshLeslie_07 2021-06-18T02:02:27Z https://community.qlik.com/t5/QlikView/Calculate-last-4-months-in-each-row/m-p/1815970#M1213020 <P>I just want to Calculate last 4 months in each row in Straight table , this is my first time to use QlikView Please help me</P><P>&nbsp;My Sample Data.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JoshLeslie_07_0-1623981328878.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/57062iA2CDFB2F5B98C47A/image-size/medium?v=v2&amp;px=400" role="button" title="JoshLeslie_07_0-1623981328878.png" alt="JoshLeslie_07_0-1623981328878.png" /></span></P><P>here is exactly what I want.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="testimage.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/57063iDB929E08E6A6D94A/image-size/medium?v=v2&amp;px=400" role="button" title="testimage.png" alt="testimage.png" /></span></P><P>but my output is wrong&nbsp; screenshot below.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JoshLeslie_07_1-1623981611191.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/57064i0A3F8457CEDC6534/image-size/medium?v=v2&amp;px=400" role="button" title="JoshLeslie_07_1-1623981611191.png" alt="JoshLeslie_07_1-1623981611191.png" /></span></P><P>&nbsp;</P><P>My Expression that I used so far , it's same result.</P><P>Max( aggr( rangesum( below( sum(Sales),0,4) ),Month))</P><P>Max(Aggr(RangeSum(Below(Sum({&lt;Month, [MonthYear], MonthYear, Year&gt;}Sales), 0, 4)), [MonthYear]))</P><P>Max( aggr( rangesum( below( sum( {$&lt;MonthYear&gt;} Sales),0,4) ),MonthYear))</P> Fri, 18 Jun 2021 02:02:27 GMT https://community.qlik.com/t5/QlikView/Calculate-last-4-months-in-each-row/m-p/1815970#M1213020 JoshLeslie_07 2021-06-18T02:02:27Z