# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for
Did you mean:
Contributor III

## Time does not display in KPI based on Client

Good Day

please assist with checking my formula, i'm having trouble displaying time in a KPI chart based on a specific client

Kind Regards

1 Solution

Accepted Solutions
MVP

Hi, if you want the Avg of LoadTurnAroundTime it could be:

Or converted to set analysis (wich gives better performance):

This will work if LoadTurnAroundTime it's the time used (not a timestamp with start/end datetime) and if you want to count every minute, (with "Hour(LoadTurnAroundTime)<>0" times lower than a full hour are ignored).

6 Replies
MVP

Hi, you don't nee two Ifs, just onme with an and, also Macth is separted with commas, not with equal sign:

Contributor III
Author

Hi @rubenmarin , thank you for your reply.

i'm getting an error with the average

i'm open to any other formula where i can get an avg time(time must exclude any zero values or negative values) on multiple accounts.

MVP

Hi, if you want the Avg of LoadTurnAroundTime it could be:

Or converted to set analysis (wich gives better performance):

This will work if LoadTurnAroundTime it's the time used (not a timestamp with start/end datetime) and if you want to count every minute, (with "Hour(LoadTurnAroundTime)<>0" times lower than a full hour are ignored).

Contributor III
Author

Thanks  Ruben,

This formula works perfect: time(AVG(if(Hour(LoadTurnAroundTime)<>0 and MATCH([DrNumber-Debtor],'UNI016','UNI017'),LoadTurnAroundTime)))

is there anyway i can include something into the formula to exclude negative values?

i have a few due to typo's :