Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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

Avarage time duration

Hello, Im using this:     
                                   Max(${<[TO shipment]>}[Over Date Time]) - Min(${<[TO shipment]>}[Conf.tDate&Time])

to get time duration. Now I would like use result time to get Avarage time for [TO shipment] in my selected data. I tried:

                                   avg (aggr (Max(${<[TO shipment]>}[Over Date Time])-Min(${<[TO shipment]>}[Conf.tDate&Time]),))

but this one dont work. Result in my tab is " - ".

Please, can anybody help me? Sorry, for my english. Thank you for your help.

1 Solution

Accepted Solutions
sunny_talwar
Not applicable

Re: Avarage time duration

May be this

Avg(Aggr(Max(${<[TO shipment]>}[Over Date Time]) - Min(${<[TO shipment]>}[Conf.tDate&Time]), [TO shipment]))

2 Replies
sunny_talwar
Not applicable

Re: Avarage time duration

May be this

Avg(Aggr(Max(${<[TO shipment]>}[Over Date Time]) - Min(${<[TO shipment]>}[Conf.tDate&Time]), [TO shipment]))

alakazam
Not applicable

Re: Avarage time duration

Thank you Sunny, it work.