Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

average function

can anyone tell me where the error is in this please?

AVG(

IF(

min(FLOOR([Work Order First Response Date])) > Max(FLOOR([Work Order Request Date])),

networkdays(Max(FLOOR([Work Order Request Date])), min(FLOOR([Work Order First Response Date]))),

networkdays(min(FLOOR([Work Order First Response Date])), Max(FLOOR([Work Order Request Date])))

)

)-1

1 Reply

Re: average function

You are trying to use an aggregation within an aggregation without using the Aggr() function

AVG(

Aggr(

IF(

min(FLOOR([Work Order First Response Date])) > Max(FLOOR([Work Order Request Date])),

networkdays(Max(FLOOR([Work Order Request Date])), min(FLOOR([Work Order First Response Date]))),

networkdays(min(FLOOR([Work Order First Response Date])), Max(FLOOR([Work Order Request Date])))

)

, AggregatingDimension/s)

)-1