topic Exclude filter and show aggregated avg on the chart. in App Development

Exclude filter and show aggregated avg on the chart.

Sat, 27 May 2017 17:01:05 GMT

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 — Sat, 27 May 2017 23:23:51 GMT

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

Sun, 28 May 2017 15:11:16 GMT

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