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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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)