topic Re: operations with Last and previous values in QlikView https://community.qlik.com/t5/QlikView/operations-with-Last-and-previous-values/m-p/1320666#M835829 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P>Dimension</P><P><STRONG>Product</STRONG></P><P></P><P>Expression</P><P><STRONG>FirstSortedValue(price, -change_date)/</STRONG><SPAN style="font-size: 13.3333px;"><STRONG>FirstSortedValue(price, -change_date, 2) - 1</STRONG></SPAN></P></BODY></HTML> Tue, 23 May 2017 14:36:07 GMT sunny_talwar 2017-05-23T14:36:07Z operations with Last and previous values https://community.qlik.com/t5/QlikView/operations-with-Last-and-previous-values/m-p/1320665#M835828 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; could you please help me to figure out this?</P><P></P><P>I have a kind of this table --&gt;</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Type<BR /></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Product<BR /></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>change_date<BR /></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>price<BR /></STRONG></TH></TR><TR><TD style="padding: 2px;">xx</TD><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">2017/02</TD><TD style="padding: 2px;">11</TD></TR><TR><TD style="padding: 2px;">xx</TD><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">2016/11</TD><TD style="padding: 2px;">9</TD></TR><TR><TD style="padding: 2px;">yyy</TD><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">2017/04</TD><TD style="padding: 2px;">5</TD></TR><TR><TD style="padding: 2px;">yyy</TD><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">2017/01</TD><TD style="padding: 2px;">10</TD></TR><TR><TD style="padding: 2px;">yyy</TD><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">2016/09</TD><TD style="padding: 2px;">6</TD></TR></TBODY></TABLE><P></P><P>And what i need is this --&gt;</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Product<BR /></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>change %Price (regarding last and previous price)<BR /></STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">(11/9)-1 = 22%</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">(5/10)-1 = -50%</TD></TR></TBODY></TABLE><P></P><P>Thanks for any help!</P><P>Gerardo</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/operations-with-Last-and-previous-values/m-p/1320665#M835828 2020-11-25T16:16:04Z Re: operations with Last and previous values https://community.qlik.com/t5/QlikView/operations-with-Last-and-previous-values/m-p/1320666#M835829 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P>Dimension</P><P><STRONG>Product</STRONG></P><P></P><P>Expression</P><P><STRONG>FirstSortedValue(price, -change_date)/</STRONG><SPAN style="font-size: 13.3333px;"><STRONG>FirstSortedValue(price, -change_date, 2) - 1</STRONG></SPAN></P></BODY></HTML> Tue, 23 May 2017 14:36:07 GMT https://community.qlik.com/t5/QlikView/operations-with-Last-and-previous-values/m-p/1320666#M835829 sunny_talwar 2017-05-23T14:36:07Z Re: operations with Last and previous values https://community.qlik.com/t5/QlikView/operations-with-Last-and-previous-values/m-p/1320667#M835830 <HTML><HEAD></HEAD><BODY><P>Works! but, what if the change is 0%. Can i do something to keep the "0%"?</P><P></P><P>Thanks!</P><P>gerardo</P></BODY></HTML> Tue, 23 May 2017 15:00:43 GMT https://community.qlik.com/t5/QlikView/operations-with-Last-and-previous-values/m-p/1320667#M835830 2017-05-23T15:00:43Z Re: operations with Last and previous values https://community.qlik.com/t5/QlikView/operations-with-Last-and-previous-values/m-p/1320668#M835831 <HTML><HEAD></HEAD><BODY><P>Uncheck 'Suppress Zero Values' on the presentation tab</P></BODY></HTML> Tue, 23 May 2017 15:02:59 GMT https://community.qlik.com/t5/QlikView/operations-with-Last-and-previous-values/m-p/1320668#M835831 sunny_talwar 2017-05-23T15:02:59Z Re: operations with Last and previous values https://community.qlik.com/t5/QlikView/operations-with-Last-and-previous-values/m-p/1320669#M835832 <HTML><HEAD></HEAD><BODY><P>Here added some extra data to show it would work in the attached qvw</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/164448_Capture.PNG" style="height: 148px; width: 620px;" /></P></BODY></HTML> Tue, 23 May 2017 15:06:32 GMT https://community.qlik.com/t5/QlikView/operations-with-Last-and-previous-values/m-p/1320669#M835832 sunny_talwar 2017-05-23T15:06:32Z Re: operations with Last and previous values https://community.qlik.com/t5/QlikView/operations-with-Last-and-previous-values/m-p/1320670#M835833 <HTML><HEAD></HEAD><BODY><P>thanks a lot!</P></BODY></HTML> Tue, 23 May 2017 15:09:55 GMT https://community.qlik.com/t5/QlikView/operations-with-Last-and-previous-values/m-p/1320670#M835833 2017-05-23T15:09:55Z