Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

nhrhah8
New Contributor II

I used RangeAvg(field1,field2) to calculate the average scores for each employee. Why isn't the Total appearing in the top row as well? (I'm using RangeAvg to eliminate null values)

1 Solution

Accepted Solutions
Digvijay_Singh
Honored Contributor III

Re: I used RangeAvg(field1,field2) to calculate the average scores for each employee. Why isn't the Total appearing in the top row as well? (I'm using RangeAvg to eliminate null values)

Don't have license to access qvw but you may try like this -

Capture.PNG

2 Replies
Digvijay_Singh
Honored Contributor III

Re: I used RangeAvg(field1,field2) to calculate the average scores for each employee. Why isn't the Total appearing in the top row as well? (I'm using RangeAvg to eliminate null values)

Don't have license to access qvw but you may try like this -

Capture.PNG

nhrhah8
New Contributor II

Re: I used RangeAvg(field1,field2) to calculate the average scores for each employee.  Why isn't the Total appearing in the top row as well?  (I'm using RangeAvg to eliminate null values)

Brilliant!  This resolved the problem.  Thanks so much for taking the time to respond!