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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculate Averages in set analysis

Good morning,

I am trying to calculate averages for the attached file. The formula I have used to calculate

Total_PreviewTime=Sum ({<PreviewedFirst={1}>}PreviewTime) and I want to calculate the Average Total_PreviewTime  and similarly for

Total_CallTime=sum(CallTime) I want to calculate Average Total_CallTime

PFA,

Thanks

12 Replies
tresesco
MVP
MVP

Perhaps the output you are getting has to be parsed as seconds. Try like:

Time#(Avg(aggr(Sum ({<PreviewedFirst={1}>}PreviewTime),Day)), 'ss')

and then apply your time format in the presentation tab.

Anonymous
Not applicable
Author

Hi Moses,

you can try

Aggr(Sum ({<PreviewedFirst={1}>}PreviewTime),Dim1,Dim2,Dim3) / Count ({<PreviewedFirst={1}>}PreviewTime)

Not applicable
Author

Thank you much for  your assistance and but Payal's is correct and the format is also correct.