Do not input private or sensitive data. View
Qlik Privacy & Cookie Policy.
Skip to main content
Unlock a world of possibilities!
Login
now and discover the exclusive benefits awaiting you.
Expand
Move to Qlik Cloud
Forums
Support
Discover
Blogs
Events
Qlik.com
Qlik Services
Qlik.com
|
Qlik Services
|
Qlik Help
|
All community
This board
Knowledge base
Users
Products
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:
Ask a Question
Help
Sign In / Register
All community
This board
Knowledge base
Users
Products
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
Qlik Community
:
All Forums
:
QlikView App Dev
:
Average count
Options
Subscribe to RSS Feed
Mark Topic as New
Mark Topic as Read
Float this Topic for Current User
Bookmark
Subscribe
Mute
Printer Friendly Page
All community
This board
Knowledge base
Users
Products
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-04-22
04:29 AM
Mark as New
Bookmark
Subscribe
Mute
Subscribe to RSS Feed
Permalink
Print
Report Inappropriate Content
Average count
I need to calculate the average number of attendances for each college and a specific term code eI am using the code (below) as this type of code has worked for me in the past with similar data.
Count
({<
COLLEGE_CODE
={'AF','BF','HF','SF'},
TERM_CODE_EFF
={'2012-13'},
[No Attendance]
={'X'}>}
[No Attendance]
)/
Count
(
Total
{<
COLLEGE_CODE
={'AF','BF','HF','SF'},
TERM_CODE_EFF
={'2012-13'},
[No Attendance]
={'X'}>}
[No Attendance]
)
However the data returned is not what I expect as I get 0.1.& 0.2 when the average should be around 100 to 140 each
Any help appreciated
Regards
Maria
Tags:
new_to_qlikview
Ditto - same here!
All forum topics
Previous Topic
Next Topic
0 Replies
Post Reply
Related Topics
Average count of a value per day of the week
Average of a count expression
Get Average of Count
How to Calculate count emp no of average score
Tags
new_to_qlikview
new to qlikview
qlikview_scripting
qlikview_layout_visuali…
qlikview_creating_analy…
qlikview
script
chart
expression
date
load
table
set_analysis
expressions
macro
analysis
scripting
pivot
set
dimension
View All ≫
Community Browser
All Forums
GeoAnalytics
QlikView Administration
QlikView App Dev
QlikView Connectivity
QlikView Integrations
Qlik NPrinting