topic Re: Get Previous Value at group in QlikView https://community.qlik.com/t5/QlikView/Get-Previous-Value-at-group/m-p/1519611#M437395 <P>That should work. Please check the screenshot what and how to use as dimensions and expressions:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.JPG" style="width: 869px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/2014iB1883B36738EF68F/image-size/large?v=v2&amp;px=999" role="button" title="Capture.JPG" alt="Capture.JPG" /></span></P> Wed, 12 Dec 2018 07:17:29 GMT tresB 2018-12-12T07:17:29Z Get Previous Value at group https://community.qlik.com/t5/QlikView/Get-Previous-Value-at-group/m-p/1519605#M437393 <P>QlikExperts,</P><P>&nbsp;</P><P>Need a solution at group level with required output (last column) as per below sample. Please assist.</P><TABLE><TBODY><TR><TD>ItemGroup</TD><TD>Item</TD><TD>Quantity</TD><TD>Output</TD></TR><TR><TD>A</TD><TD>Item-A</TD><TD>20</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</TD></TR><TR><TD>A</TD><TD>Item-B</TD><TD>3</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 60</TD></TR><TR><TD>A</TD><TD>Item-C</TD><TD>6</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 360</TD></TR><TR><TD>A</TD><TD>Item-D</TD><TD>4</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,440</TD></TR><TR><TD>A</TD><TD>Item-E</TD><TD>5</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7,200</TD></TR><TR><TD>B</TD><TD>Item-A</TD><TD>12</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12</TD></TR><TR><TD>B</TD><TD>Item-B</TD><TD>5</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 60</TD></TR><TR><TD>B</TD><TD>Item-C</TD><TD>17</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,020</TD></TR><TR><TD>B</TD><TD>Item-D</TD><TD>16</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 16,320</TD></TR><TR><TD>B</TD><TD>Item-E</TD><TD>8</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,30,560</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>One of the&nbsp; post read that the solution at expression level is =Quantity * Alt(Above(Expr1),1)</P><P>Need a group level solution</P> Sat, 16 Nov 2024 04:59:11 GMT https://community.qlik.com/t5/QlikView/Get-Previous-Value-at-group/m-p/1519605#M437393 Anonymous 2024-11-16T04:59:11Z Re: Get Previous Value at group https://community.qlik.com/t5/QlikView/Get-Previous-Value-at-group/m-p/1519611#M437395 <P>That should work. Please check the screenshot what and how to use as dimensions and expressions:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.JPG" style="width: 869px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/2014iB1883B36738EF68F/image-size/large?v=v2&amp;px=999" role="button" title="Capture.JPG" alt="Capture.JPG" /></span></P> Wed, 12 Dec 2018 07:17:29 GMT https://community.qlik.com/t5/QlikView/Get-Previous-Value-at-group/m-p/1519611#M437395 tresB 2018-12-12T07:17:29Z