topic Re: Guidance on Sales Person v Team Average in QlikView

Guidance on Sales Person v Team Average

pkelly — Mon, 15 Feb 2016 23:20:31 GMT

Hi All

Looking for some guidance on charts...

I have data similar to the following...

The user will filter on a sales person e.g. Paul Kelly.

I will show a summary of sales by product type for this sales person - straightforward.

What I would like to do beside this is show the average sales data for the users in the sales team in this example Panels.

Bearing in mind that we will have filtered on the user Paul Kelly, how do I ignore this filter (assuming set analysis) and show the average sales for the sales team that the filtered user belongs to?

Any assistance greatly appreciated.

Regards

Paul

Re: Guidance on Sales Person v Team Average

petter — Mon, 15 Feb 2016 23:38:58 GMT

Sum for the team could be calculated in either of these ways:

Sum( {1} TOTAL <SalesTeam> Value) // When the SalesTeam occurs as a dimension in the chart

Aggr(NODISTINCT Sum( Value) , SalesTeam ) // When the SalesTeam does not occur as a dimension...

Re: Guidance on Sales Person v Team Average

sunny_talwar — Tue, 16 Feb 2016 00:41:07 GMT

Not sure what type of object you are planning to use, but may be you can explore something like this:

Avg({<[Sales Person] = , [Sales Team] = p([Sales Team])>} Value)