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
