Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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)