topic Re: Accumulation in QlikView https://community.qlik.com/t5/QlikView/Accumulation/m-p/903727#M314286 <HTML><HEAD></HEAD><BODY><P>Is this just a sample or full data set?</P><P>What result do you expect for the first line in Raw Data(which currency)?</P><P>At the moment you have one exchange rate for each currency.</P></BODY></HTML> Mon, 13 Apr 2015 15:21:49 GMT robert_mika 2015-04-13T15:21:49Z Accumulation https://community.qlik.com/t5/QlikView/Accumulation/m-p/903726#M314285 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>I have one doubt could you please help me in this.</P><P></P><P>I have data like below</P><P></P><P>Raw data sheet and Exchange sheet. attached here.</P><P></P><P>Could you please let me know how can i achieve this requirement.</P><P></P><P>Find out the Start date &amp; End Date in the fact table (Raw Data) and identify the latest Exchange Rates for the currency only get one more additional column as Exchjnage Rate in the output file</P></BODY></HTML> Mon, 13 Apr 2015 14:40:48 GMT https://community.qlik.com/t5/QlikView/Accumulation/m-p/903726#M314285 2015-04-13T14:40:48Z Re: Accumulation https://community.qlik.com/t5/QlikView/Accumulation/m-p/903727#M314286 <HTML><HEAD></HEAD><BODY><P>Is this just a sample or full data set?</P><P>What result do you expect for the first line in Raw Data(which currency)?</P><P>At the moment you have one exchange rate for each currency.</P></BODY></HTML> Mon, 13 Apr 2015 15:21:49 GMT https://community.qlik.com/t5/QlikView/Accumulation/m-p/903727#M314286 robert_mika 2015-04-13T15:21:49Z Re: Accumulation https://community.qlik.com/t5/QlikView/Accumulation/m-p/903728#M314287 <HTML><HEAD></HEAD><BODY><P>i guess, you can load your data using SORT BY in the end of your load</P><P>and than create a variable and use peak() where you input your table, your column and tell the function to find the last row (-1)</P></BODY></HTML> Mon, 13 Apr 2015 19:51:23 GMT https://community.qlik.com/t5/QlikView/Accumulation/m-p/903728#M314287 2015-04-13T19:51:23Z