Discussion board where members can get started with QlikView.
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.
Go to Solution.
= avg(aggr(sum(Salary), Title))
View solution in original post
avg(TOTAL <Title> Salary)
Thank you massimo it worked