Hi All,
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.
Now they are deriving quarter 2 data by doing difference of (YTD data till Jun 2018 - YTD data till Mar 2018). They do the samething for quarter 3 data i.e (YTD data till Sep 2018 - YTD data till Dec 2018).
How can we implement this logic in qlik sense. Please share your thoughts.
Data for this will come in below format
City 2018 Q1 Revenue 2018 Q1 Direct Operating Profit
A 100 250
B 300 500
C 400 200
We receive the YTD data in the above format in every quarter.
Thanks
Prashanth.