Hi guys,
I have dates, A data and B data in excel file. I would like to move them into Qlik and calculate C data based on A and B .
Dates |
A |
B |
C - calculated using a formula in Qlik |
C - explanation |
25.06.2023 |
680 |
20 |
- |
- |
26.06.2023 |
540 |
13 |
153 |
=B2-B3+C3 |
27.06.2023 |
520 |
14 |
34 |
=B3-B4+C4 |
28.06.2023 |
674 |
10 |
-144 |
=B4-B5+C5 |
29.06.2023 |
700 |
7 |
-19 |
=B5-B6+C6 |
30.06.2023 |
530 |
15 |
185 |
=B6-B7+C7 |
Total |
=AVERAGE(B2:B7) |
=SUM(C2:C7) |
209 |
=SUM(D2:D7) |
My issue appeard in the total of the June for C data. Do you have any idea how to calculate summary of the June in Qlik?