Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
alexandernatale
Creator II
Creator II

Difference value start month and final month...COVID 19

 Hello!

I have a problem.
I have a data table of Covid19. In this table i have 
| Date | Region | Recovered | Death | Hospitalized | ecc..
The values of the patients are cumulative: for each day I have the total value but no the incremetal value for day.

My goal it's calculate the month trend --> for example for May I would like to calculate the difference of recovered at the end of the month and at the beginning of the month to understand the monthly increase.

I also have the data table I have a master calendar table.

I would like to realize a histogram o another chart..

Suggest? 

@Michael_Tarallo please help me 😓

3 Replies
JustinDallas
Specialist III
Specialist III

Hello Alexandra,

May I suggest that you add some dummy data to your question.  And then show us a chart of what you expect the data to look like?  It makes people want to help you because the objective is clearly shown.

alexandernatale
Creator II
Creator II
Author

thanks for the reply  @JustinDallas 

I attached a example data and what i would create a data or graph..

Schermata 2020-05-28 alle 22.09.06.pngSchermata 2020-05-28 alle 22.09.20.png

 

 

 

 

alexandernatale
Creator II
Creator II
Author

To complete the discussion, the problem can also be seen in this other way: Having an initial warehouse with inventory at the beginning of the month and one at the end of the month, I want to evaluate the increase / decrease of inventories in the warehouse considering therefore the initial inventory on day 1 of the month and the final inventory on day 31 of the same month. This calculation, for all months