adding values below 25% of the total average to a chart using an if statement

[Anonymous]

I have an excel file with 400 values and I only want to display the values that are 25% or less of the total average value on a Qlik Sense chart / table.using an if statement

For example, if I have an total average value of 100 I want to display all values of 25 and less.

Thanks in advance

[Anonymous · Accepted solution]

Hi All

I got the answer I needed as follows and unchecking the include null values tab

aggr(if (avg(Sales)/avg(TOTAL Sales) <0.25, Sales),Sales)

thanks for your help