Exclude filter and show aggregated avg on the chart.

[#1]

Hello!

Here is the problem:

There are 2 fields: customer's name, number of sales

I have a filter, which is chosen and blocked for the whole app. That is the ID of a customer.

I need to show on the same chart the customer's number of sales and avg number of sales for the whole population.

I don't understand how to show aggregated information in this case.

[hector_munoz]

Hi Ray,

If you want to avoid selections done in 'customer' field use the following:

Sum({<customer>} sales)

If you are starting with Qlik I would recommend you to take a look to set analysis functionality.

Regards,
H

[#3]

Ty for your answer, Hector.

Unfortunately it didn't help. Now I see all sales of all customers, but i need information about avg number for the whole population.

Ray