Skip to main content
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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

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

- Marcus

Partner - Specialist III
Partner - Specialist III

You can use the Set expression to avoid the Filter selections

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

Partner - Specialist III
Partner - Specialist III

To understand what is suggested read more about Set Analysis.