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
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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
‎2011-05-25 11:37 AM

Average in graph

Hi,

I am trying to show the avergae Incident Rate in the column for the Qlikview attached. I have worked out the incident rate and I know that the average is 3.01, I want this showing in the right hand column.

The trendline function will not suffice here as I need to use the average for some other calcuations. Please help???

Dave

1.qvw
5,974 Views
0 Likes
1 Solution

Accepted Solutions
johnw
Champion III
Champion III
‎2011-05-25 07:17 PM

This?  "Total" tells it to ignore your dimension values.

12*sum(total [CM Tickets])/sum(total Population)

View solution in original post

305 Views
2 Replies
johnw
Champion III
Champion III
‎2011-05-25 07:17 PM

This?  "Total" tells it to ignore your dimension values.

12*sum(total [CM Tickets])/sum(total Population)

306 Views
Not applicable
‎2011-05-26 05:12 AM
Author

In response to johnw

John,

Had to tweak it slightly but works a treat. This total function will enable me to do a few reports

305 Views
0 Likes