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
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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
Labels (1)
Labels
457 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.

399 Views
0 Likes