Group Average

[RemyMP]

Hi Everyone! 

I'm relatively new to Qlik Sense, and I'm trying to build a report. Essentially, I'm looking to display (in numbers - using KPI) the average of a department name. Would anyone be able to help me out for what expression I would need? 

Example:

Employee Name |  Dept | Sales

John |  Canada Sales | 500

Richard |  Canada Sales | 750

Lucy | US Sales | 800

[pradosh_thakur]

Hi

If you are asking for average of sales for dept name it can be done.

avg(Sales)

 will give you that

If you want avg of sales for particular dept name , for example Canada Sales below is the expression

avg({<Dept={'Canada Sales'}>}Sales)

[Channa]

aggr(avg(sales),dept)