Count tickets based on status that changes between dates

[neetking]

Hi everyone,

I am new to Qlik Sense, I want to know if it is possible to have a field that changes if we change the date in our sheet (dashboard), here is an example to get an idea of what I want to do:

Table Ticket:

-------------------------

ID_Ticket

Date_Created

Date_Resolve

Status

-------------------------

- The expression I want to achieve: Number of tickets open in the period selected (KPI)

I think it will be something like this

Sum(

If Status = "Open" Then count ID_Ticket
If Status = "Closed" And Date_Resolve > Date_Selected Then count ID_Ticket
If Statut = "Resolved" And Date_Resolve > Date_Selected Then count ID_Ticket

)

Thank you in advance for your reply