Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Average if (conditional)

Hi,

I have several task in database.

All of them have a begging and end date.

Ex.

task_begin: 12/03/2012 14:30

task_end: 21/03/2012 18:30

task_duration: NetWorkDays(task_begin, task_end)

I want to calculate the average task duration in days.

But due to data quality, I have to remove the values where (duration < 0)

How can I calculate the average without the (duration < 0)?

EX: if(duration > 0;day(avg(Duracao_dias_uteis)))

Regards,

Gonçalo

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Average if (conditional)

Goncalo

Try this:

Avg(if(duration > 0, Duracao_dias_uteis))

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

1 Reply
Highlighted
MVP
MVP

Average if (conditional)

Goncalo

Try this:

Avg(if(duration > 0, Duracao_dias_uteis))

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post