Hello,
I am very new to QlikView and have a problem where I havn't found already existing solutions in the community..
I have 4 tables with exactly same structure:
The Material Number is unique like a primary key.
| Material Number | Costs total | costs labour | costs material |
|---|
| 1 | 1000 | 500 | 500 |
| 2 | 2000 | 1500 | 500 |
The first table one has information for Q1,
the 2nd table has information for Q2 + Q1,
the 3rd table has information for Q3 + Q2 + Q1,
the 4th table has information for Q4 + Q3 + Q2 + Q1
I need information for each quarter separately.
For example for getting the information for Q3 I need to do Q3-Q2 based on each Material Number.
The count of Material Numbers is also getting higher from quarter to quarter.
The information of the quarter is only mentioned in the title of the excel file: Q1_Material.qvd, Q1_Q2_Material.qvd, etc.
How can I do this in the script for all the quarters of a year?
Thank you very much!
Kind regards,
Martin
