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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
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