Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I started to learn and to work with Qlik sense but i have an issue to calculate a KPI including a condition.
So I have this table :
Start task | Middle task | End task | Id_task |
01/10/2019 | 29/10/2019 | 22/11/2019 | 125A |
08/10/2019 | 12/11/2019 | 21/11/2019 | 125B |
07/10/2019 | 22/09/2019 | 26/09/2019 | 124A |
18/08/2019 | 26/09/2019 | 30/09/2019 | 127X |
17/06/2019 | 01/08/2019 | 07/08/2019 | 130E |
11/01/2019 | 06/01/2019 | 07/01/2019 | 140B |
12/10/2019 | 27/10/2019 | 04/11/2019 | 120V |
05/07/2018 | 10/08/2018 | 17/08/2018 | 140C |
01/06/2019 | 26/06/2019 | 26/06/2019 | 180R |
18/08/2019 | 11/09/2019 | 17/09/2019 | 150T |
01/11/2019 | 22/10/2019 | 28/10/2019 | 140C |
01/12/2019 | 19/12/2019 | 20/12/2019 | 160Z |
01/05/2019 | 09/06/2019 | 16/06/2019 | 140Z |
The first column is the date of the started tasks, the second is the date when the task is half completed. The third column is the date of the ending, and finally I have the id's tasks.
So I would like to create different KPI and includind a conditional.
For example I want to calculate the number of half completed tasks witch the duration is less than 30 days.
I tried to use the Aggr function, but I don't know how it's work.
Thank you for you helping.
Ps : I am also lookking for tutorial for beginners with explication step by step, if you know where i can find this, i will be very happy to learn about Qlik sense.
May be this
Count(DISTINCT {<Id_task = {"=[Middle task] - [Start task] < 30"}>} Id_task)
May be this
Count(DISTINCT {<Id_task = {"=[Middle task] - [Start task] < 30"}>} Id_task)