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: 
rajaqliks
Contributor III
Contributor III

Avg in pivot table as a single column

Hi Folks,

I need to display avg as a new column on Pivot table,  i am adding qvw as a sample and result as follows.

avg  =  sum(L12 Total)/count(weeks)

Capture.PNG

 

1 Reply
bharathadde
Creator II
Creator II

create new expression for Average
=Column(1)/ Count(weeks)