topic Re: Previous price by article in QlikView https://community.qlik.com/t5/QlikView/Previous-price-by-article/m-p/326174#M708658 <HTML><HEAD></HEAD><BODY><P>Aloah</P><P></P><P>I have attached a demo using FirstSortedValue with your data. I think this does what you want.</P><P></P><P>Hope this helps</P><P>Jonathan</P></BODY></HTML> Wed, 05 Oct 2011 19:56:41 GMT jonathandienst 2011-10-05T19:56:41Z Previous price by article https://community.qlik.com/t5/QlikView/Previous-price-by-article/m-p/326168#M708649 <HTML><HEAD></HEAD><BODY><P>Hello community,</P><P></P><P>I'm trying to find out the price differences by articles from our sales table. </P><P>The fields uses are </P><P></P><P>orderid</P><P>orderdate</P><P>articleid</P><P>price</P><P>amount</P><P><BR />I need to show the difference concerning the price from the "current" order&nbsp; to the previous order. If an article is sold more often also only the last order vs. last order -1 is relevant. Has someone a hint for my how to implement this in loading script?</P><P></P><P>Thanks in advance</P><P></P><P>Aloah</P></BODY></HTML> Tue, 06 Sep 2011 12:15:33 GMT https://community.qlik.com/t5/QlikView/Previous-price-by-article/m-p/326168#M708649 2011-09-06T12:15:33Z Previous price by article https://community.qlik.com/t5/QlikView/Previous-price-by-article/m-p/326169#M708650 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>you can create a new tablebox&nbsp; (ordrid, aticleid, price). go to properties and sort descending ordid. make sure to make a selection on the last articlid somewhere on the sheet. you should see if there is a difference in the 2 first listed prices</P></BODY></HTML> Tue, 06 Sep 2011 14:42:46 GMT https://community.qlik.com/t5/QlikView/Previous-price-by-article/m-p/326169#M708650 2011-09-06T14:42:46Z Previous price by article https://community.qlik.com/t5/QlikView/Previous-price-by-article/m-p/326170#M708651 <HTML><HEAD></HEAD><BODY><P><EM>Hi Aloah,</EM></P><P></P><P><EM>Is the "orderdate" field in your table a DateTime or just Date? Also, can you post some sample data and I can work an example for you.</EM></P><P></P><P><EM>Cheers - DV</EM></P></BODY></HTML> Tue, 06 Sep 2011 15:06:38 GMT https://community.qlik.com/t5/QlikView/Previous-price-by-article/m-p/326170#M708651 IAMDV 2011-09-06T15:06:38Z Previous price by article https://community.qlik.com/t5/QlikView/Previous-price-by-article/m-p/326171#M708652 <HTML><HEAD></HEAD><BODY><P>Hi DV,</P><P></P><P>orderdate is datetime. </P><P></P><P>Data looks like</P><P></P><P>orderid&nbsp;&nbsp;&nbsp;&nbsp; orderdate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; articleid&nbsp;&nbsp; price&nbsp;&nbsp;&nbsp;&nbsp; amount</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01.09.2011 00:00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 02.09.2011 00:00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 03.09.2011 00:00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 19</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 06.09.2011 00:00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 06.09.2011 00:00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 07.09.2011 00:00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 08.09.2011 00:00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 55</P><P></P><P></P><P>I'm trying to show within the chart that article a1 was bought last time with price 13 last previous order was with price 12. the order on 1.9.2011 with price of 10 isn't relevant. Only the current and the prev order are relevant. </P><P>eg. </P><P></P><P>last order with price 13 (+1) or something like that. </P><P></P><P>Thanks</P><P></P><P>Kind Regards</P><P><BR />Aloah</P></BODY></HTML> Sun, 25 Sep 2011 08:14:34 GMT https://community.qlik.com/t5/QlikView/Previous-price-by-article/m-p/326171#M708652 2011-09-25T08:14:34Z Re: Previous price by article https://community.qlik.com/t5/QlikView/Previous-price-by-article/m-p/326172#M708654 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: trebuchet ms,geneva;"><EM>Hi Aloah,</EM></SPAN></P><P></P><P><SPAN style="font-family: trebuchet ms,geneva;"><EM>Sorry for delay in replying back. Have you got this working? or do you still need help?</EM></SPAN></P><P></P><P><SPAN style="font-family: trebuchet ms,geneva;"><EM>Thanks,</EM></SPAN></P><P><STRONG style="font-family: trebuchet ms,geneva;"><EM>DV</EM></STRONG></P></BODY></HTML> Tue, 27 Sep 2011 16:29:19 GMT https://community.qlik.com/t5/QlikView/Previous-price-by-article/m-p/326172#M708654 IAMDV 2011-09-27T16:29:19Z Previous price by article https://community.qlik.com/t5/QlikView/Previous-price-by-article/m-p/326173#M708656 <HTML><HEAD></HEAD><BODY><P>Hi DV,</P><P><BR />I'm still looking for a solution.</P><P><BR />Thanks</P><P><BR />Aloah</P></BODY></HTML> Wed, 05 Oct 2011 18:17:55 GMT https://community.qlik.com/t5/QlikView/Previous-price-by-article/m-p/326173#M708656 2011-10-05T18:17:55Z Re: Previous price by article https://community.qlik.com/t5/QlikView/Previous-price-by-article/m-p/326174#M708658 <HTML><HEAD></HEAD><BODY><P>Aloah</P><P></P><P>I have attached a demo using FirstSortedValue with your data. I think this does what you want.</P><P></P><P>Hope this helps</P><P>Jonathan</P></BODY></HTML> Wed, 05 Oct 2011 19:56:41 GMT https://community.qlik.com/t5/QlikView/Previous-price-by-article/m-p/326174#M708658 jonathandienst 2011-10-05T19:56:41Z