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

Calculating the average/value

LOCATIONFACILITYWAITING TIME
LOCATION 1FACILITY 110 SECS
LOCATION 1FACILITY 25 SECS
LOCATION 1FACILITY 320 SECS
LOCATION 2FACILITY 110 SECS
LOCATION 2FACILITY 20 SEC
LOCATION 2FACILITY 310 SECS

I need to calculate the average waiting time and make it appear in a text box for both locations should be ( 9.2 SECS) average waiting time for location 1 should be (11.7 SECS) and location 2 should be (6.7 SECS) and also make the individual value appear as it gets filtered from the other tables.