Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
daniel1017
Contributor II
Contributor II

Time Average doest not match

Hello Team, Im trying to get the average of time but when I try this formula it doesnt match with the avg of the excel file, do you know what is the problem? Here some examples.

daniel1017_0-1630434100531.png

daniel1017_1-1630434136214.png

Taking August month

On the excel file I have 00:00:24 of Avg but in QV it appears as 00:00:23, could someone can help me please?

The Expression that I-am using on QV is this one "Interval(Avg([Ch_AMS_K_ASA No Transfer]))"

Thank you so much for your help

 

Dan

1 Reply
sunny_talwar
MVP
MVP

Not entirely sure, but this could be because of Rounding Errors.

Community Browser