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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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