KPI counting with conditionnal

foxwhite — Mon, 30 Dec 2019 14:31:08 GMT

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.

Re: KPI counting with conditionnal

sunny_talwar — Mon, 30 Dec 2019 14:36:47 GMT

May be this

Count(DISTINCT {<Id_task = {"=[Middle task] - [Start task] < 30"}>} Id_task)

topic KPI counting with conditionnal in App Development

KPI counting with conditionnal

Re: KPI counting with conditionnal