Calculate stock based on input and output date

[Charles80]

Hey guys. I hope you are all well.

I would like to try to get the following help from you: We have a database of suspected fraud cases for review. We only have the date of registration of the case and the date of completion of the analysis of the case.

Would it be possible to calculate the stock of cases not analyzed month by month?

Thank you very much in advance.

[Vegar · Accepted solution]

Try to make an master calendar with date and month dimensions. When you have this table then try to intervalmatch your dates on to your date of registration and date of completion.

[Charles80]

Hi @Vegar . Amazing friend. I did not know this function of qlik sense. Perfect.
I had to study a little about IntervalMatch and take a lot of tests. But it worked for the proposal that was put here. Thank you so much.