Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Re: A total with NUM, not affected by filters

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

- Marcus

krishnacbe
Valued Contributor III

Re: A total with NUM, not affected by filters

You can use the Set expression to avoid the Filter selections

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

MindaugasBacius
Valued Contributor II

Re: A total with NUM, not affected by filters

To understand what is suggested read more about Set Analysis.

Community Browser