Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Avg - issue

Hi All,

I need to show avg salary value inplace of 0, for example

I have title X itz avg salary is 1500, 1500 value should display in first row as well for the Name Kim, but

it is showing once.

  

TitleNameSalaryAvg Salary
XKim20000
XJane10001500
YKelly40000
YSally30003500
ZKiran50005000

Expected

  

TitleNameSalaryAvg Salary
XKim

2000

1500
XJane10001500
YKelly40003500
YSally30003500
ZKiran50005000

Thanks

1 Solution

Accepted Solutions
Highlighted
oknotsen
Honored Contributor III

Re: Avg - issue

Try this:

= avg(aggr(sum(Salary), Title))

May you live in interesting times!
3 Replies
Highlighted
oknotsen
Honored Contributor III

Re: Avg - issue

Try this:

= avg(aggr(sum(Salary), Title))

May you live in interesting times!
MVP
MVP

Re: Avg - issue

avg(TOTAL <Title> Salary)

Not applicable

Re: Avg - issue

Thank you massimo it worked