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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2013-07-19 06:20 AM

Avg calculation

Hi,

can any one help me...

i have below table in excel it is showing 6.111 but QV if i use avg(rating) it is showing 4.00. why is this? but 6.111 is correct one...

CallNoCSatRemarksRating
2564882Extremely Satisfied7
2312312Satisfied6
2323213Satisfied6
2123123Extremely Satisfied7
23123Satisfied6
231231Satisfied6
45645645Somewhat Satisfied5
4353534Satisfied6
123546Satisfied6
6.111
320 Views
0 Likes
1 Reply
luciancotea
Specialist
Specialist
‎2013-07-19 06:25 AM

Depends on your data structure in QlikView. Better post an example qvw.

262 Views
0 Likes