topic Re: Quantity and rate from different periods in QlikView https://community.qlik.com/t5/QlikView/Quantity-and-rate-from-different-periods/m-p/1456778#M611734 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>1:do you use period in the table ?</P><P></P><P></P><P>please attach a sample to work on ..</P></BODY></HTML> Fri, 29 Dec 2017 14:37:39 GMT pradosh_thakur 2017-12-29T14:37:39Z Quantity and rate from different periods https://community.qlik.com/t5/QlikView/Quantity-and-rate-from-different-periods/m-p/1456776#M611732 <HTML><HEAD></HEAD><BODY><P>Dear Experts,</P><P></P><P>I have two tables one with quantities and one with rates, period and item wise. joined through composite key item+period. Now </P><P>Sum(quantity*rate) is giving perfect result for selected period. </P><P></P><P>I want if the selected periods dont have rates then it should pick rates from the previous period.</P><P></P><P>Regards</P><P></P><P>Zahid Rahim</P></BODY></HTML> Fri, 29 Dec 2017 12:55:36 GMT https://community.qlik.com/t5/QlikView/Quantity-and-rate-from-different-periods/m-p/1456776#M611732 zahidrahim_ocp 2017-12-29T12:55:36Z Re: Quantity and rate from different periods https://community.qlik.com/t5/QlikView/Quantity-and-rate-from-different-periods/m-p/1456777#M611733 <HTML><HEAD></HEAD><BODY><P>I am just providing an idea ..</P><P></P><P></P><P>Expression 1 :<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Sum(quantity*rate)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Expression 2 :sum(quantity*Alt(rate,1)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">or</SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Expression 2 :sum(quantity*Alt(rate,Previous(Period))</SPAN></P><P></P></BODY></HTML> Fri, 29 Dec 2017 13:45:48 GMT https://community.qlik.com/t5/QlikView/Quantity-and-rate-from-different-periods/m-p/1456777#M611733 Anonymous 2017-12-29T13:45:48Z Re: Quantity and rate from different periods https://community.qlik.com/t5/QlikView/Quantity-and-rate-from-different-periods/m-p/1456778#M611734 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>1:do you use period in the table ?</P><P></P><P></P><P>please attach a sample to work on ..</P></BODY></HTML> Fri, 29 Dec 2017 14:37:39 GMT https://community.qlik.com/t5/QlikView/Quantity-and-rate-from-different-periods/m-p/1456778#M611734 pradosh_thakur 2017-12-29T14:37:39Z Re: Quantity and rate from different periods https://community.qlik.com/t5/QlikView/Quantity-and-rate-from-different-periods/m-p/1456779#M611735 <HTML><HEAD></HEAD><BODY><P> How the Previous(Period) get identified ?</P></BODY></HTML> Tue, 02 Jan 2018 06:05:29 GMT https://community.qlik.com/t5/QlikView/Quantity-and-rate-from-different-periods/m-p/1456779#M611735 zahidrahim_ocp 2018-01-02T06:05:29Z Re: Quantity and rate from different periods https://community.qlik.com/t5/QlikView/Quantity-and-rate-from-different-periods/m-p/1456780#M611736 <HTML><HEAD></HEAD><BODY><P>Yes Periods exist in the table. only current period don't have any data but rates exist.</P></BODY></HTML> Tue, 02 Jan 2018 06:06:12 GMT https://community.qlik.com/t5/QlikView/Quantity-and-rate-from-different-periods/m-p/1456780#M611736 zahidrahim_ocp 2018-01-02T06:06:12Z Re: Quantity and rate from different periods https://community.qlik.com/t5/QlikView/Quantity-and-rate-from-different-periods/m-p/1456781#M611737 <HTML><HEAD></HEAD><BODY><P><EM>It's a missing data scenario...I would suggest you to start populating the&nbsp; missing data in the back end ...check this post </EM></P><P><EM><A href="https://community.qlik.com/thread/191491">Generating the missing data with previous data</A></EM></P></BODY></HTML> Tue, 02 Jan 2018 06:16:21 GMT https://community.qlik.com/t5/QlikView/Quantity-and-rate-from-different-periods/m-p/1456781#M611737 avinashelite 2018-01-02T06:16:21Z