Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted
Specialist II
Specialist II

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.

Highlighted
Creator
Creator

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

 

 

 

 

Highlighted
Creator
Creator

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