Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
savithri_n_s
Contributor III
Contributor III

How to add average label

have calculated the average of rows. How do i add label average in last column after Jan2018?

4 Replies
Digvijay_Singh

Don't have access to qvw but may be this can work-

Capture.PNG

isingh30
Specialist
Specialist

Expression - Label

vishsaggi
Champion III
Champion III

If this is a pivot table just check Show partial sums in presentation tab of that Field CurrentMonth/Year. Then change the Label for totals to Average.

Capture.PNG

shiveshsingh
Master
Master

Capture.JPG

On Presentation tab, you can give label whatever you want for the total