| Name | Quarter | Type | Amount | Case |
|---|
| Company A | 2018Q3 | A | 9579761.4 | 15633 |
| Company B | 2018Q3 | A | 2678371.3 | 330 |
| Company C | 2018Q3 | A | 204 | 0 |
| Company A | 2018Q3 | B | 519343.3 | 24 |
| Company B | 2018Q3 | B | 0 | 0 |
| Company C | 2018Q3 | B | 1004534 | 4 |
| Company A | 2018Q3 | C | 3298902.2 | 22370 |
| Company B | 2018Q3 | C | 0 | 0 |
| Company C | 2018Q3 | C | 574220.8 | 873 |
| Company A | 2018Q3 | Total | 13398006.9 | 38027 |
| Company B | 2018Q3 | Total | 2678371.3 | 330 |
| Company C | 2018Q3 | Total | 1578958.8 | 877 |
Every month I will receive data from external source which calculated the year to date total. I would like to transform the data as above table for easier analysis e.g. quarter to quarter, year to date, year to year ... However, since the data are already calculated year to date amount. Any way to use previous quarter's records to store the amount for the new quarter in loading scripts? For example, for company A, 2018Q2, Type A may be 4000000. And so I can store only the 4579761.4 for Q3. Or it's better to store the year-to-date total instead of quarter amount?
I'm totally new in qlikview and your input is greatly appreciated.
