Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
c_latham
Contributor III
Contributor III

RangeAvg as KPI per date

Hi All,

I am attempting to use what I think needs to be RangeAvg.

Data looks like the following in a table and the total is correct.

DepartureVisit Key

MPH

Totals 26.76
26/01/20201121830.72
26/01/20202535222.81

 

However when I do the following in a KPI to try and replicate the total I get 19.29 :

Rangeavg(count([Visit Key])/(round( (max(t_put) - min(t_put) ) / (1/24), .01)))

Do I need to use Aggr as well?

Thanks in advance!

Labels (1)
1 Reply
lironbaram
Partner - Master III
Partner - Master III

hi 

in general range function are useful in charts and table 

in KPI assuming you want to get the average of the rows you should use aggr with simple avg