https://community.qlik.com/t5/App-Development/How-to-calculate-quarterly-values-from-YTD-data/m-p/1560157#M40806 <P>Hi All,</P><P>We have a requirement where user provides a spreadsheet every quarter let us say in June 2018 we receive a file which has YTD data till Mar 2018. Similarly we receive another file in Sep 2018 which has YTD data till Jun 2018. This process continues for all the quarters.</P><P>Now they are deriving quarter 2 data by doing difference of (YTD data till Jun 2018 -&nbsp;YTD data till Mar 2018). They do the samething for quarter 3 data i.e&nbsp;(YTD data till Sep 2018 -&nbsp;YTD data till Dec 2018).</P><P>How can we implement this logic in qlik sense. Please share your thoughts.</P><P>Data for this will come in below format</P><P>City&nbsp; &nbsp; &nbsp; &nbsp;2018 Q1 Revenue&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2018 Q1 Direct Operating Profit</P><P>A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;250</P><P>B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 300&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;500</P><P>C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 400&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200</P><P>&nbsp;</P><P>We receive the YTD data in the above format in every quarter.</P><P>&nbsp;</P><P>Thanks</P><P>Prashanth.</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 25 Mar 2019 06:06:46 GMT prashanthyacham 2019-03-25T06:06:46Z https://community.qlik.com/t5/App-Development/How-to-calculate-quarterly-values-from-YTD-data/m-p/1560157#M40806 <P>Hi All,</P><P>We have a requirement where user provides a spreadsheet every quarter let us say in June 2018 we receive a file which has YTD data till Mar 2018. Similarly we receive another file in Sep 2018 which has YTD data till Jun 2018. This process continues for all the quarters.</P><P>Now they are deriving quarter 2 data by doing difference of (YTD data till Jun 2018 -&nbsp;YTD data till Mar 2018). They do the samething for quarter 3 data i.e&nbsp;(YTD data till Sep 2018 -&nbsp;YTD data till Dec 2018).</P><P>How can we implement this logic in qlik sense. Please share your thoughts.</P><P>Data for this will come in below format</P><P>City&nbsp; &nbsp; &nbsp; &nbsp;2018 Q1 Revenue&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2018 Q1 Direct Operating Profit</P><P>A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;250</P><P>B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 300&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;500</P><P>C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 400&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200</P><P>&nbsp;</P><P>We receive the YTD data in the above format in every quarter.</P><P>&nbsp;</P><P>Thanks</P><P>Prashanth.</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 25 Mar 2019 06:06:46 GMT https://community.qlik.com/t5/App-Development/How-to-calculate-quarterly-values-from-YTD-data/m-p/1560157#M40806 prashanthyacham 2019-03-25T06:06:46Z