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

I need to have an average on the top of each column of a pivot table in qliksense

Hi All I have the following pivot table (without the red color one).

Employee
Appointment DateAverage     
 06-14-202106-15-202206-16-202306-17-202406-18-2025and so on 
 Avg: 3.33Avg: 3.35Avg: 3.16Avg: 2.66Avg: 2.5Avg: 3.16 
A415444 
B3-4334 
D5565-- 
E35-44- 
F-4--45 
G564--6 

 Now I need as the Average value in each column as displayed in the image. It should also alter the result accordingly when I select employee(s).

Can anybody help me out to achieve this?

 

Thanks in Advance.

Madhab Sikder

10 Replies
Vegar
MVP
MVP

Glad I could be of help.