Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

A total with NUM, not affected by filters

I am trying to display average length in a text box with =NUM (Avg(AMSLength),'#,##0') .

When I apply a filter, the average length changes to the average for the selected values.

How can I get an average length for all values in the database, not affected by filters?

3 Replies
marcus_sommer

Try it with: =NUM (Avg({1} AMSLength),'#,##0')

- Marcus

krishnacbe
Partner - Specialist III
Partner - Specialist III

You can use the Set expression to avoid the Filter selections

=NUM (Avg({1}AMSLength),'#,##0')

MindaugasBacius
Partner - Specialist III
Partner - Specialist III

To understand what is suggested read more about Set Analysis.