Qlik Community

Qlik Sense App Development

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

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Avg function not giving any value in graph.

Hi,

I have below kind of data available for my enquiries, and I am trying to calculate Avg Rate. while computing avg rate, I have to ignore null rate and negative rate from table. Can somebody help me to put correct formulate to compute this.(values are smudged for privacy reason)

currently I have put below as formula

Avg(Aggr(Only({<Status = {'*Order*'},UNITRATE>= {0} >} UNITRATE), ENQNO)) AND MY GRAPH SHOWS AS BELOW.

1 Solution

Accepted Solutions
sunny_talwar
Not applicable

Re: Avg function not giving any value in graph.

May be like this

Avg(Aggr(Only({<Status = {'*Order*'}, UNITRATE = {'>0'}>} UNITRATE), ENQNO))

1 Reply
sunny_talwar
Not applicable

Re: Avg function not giving any value in graph.

May be like this

Avg(Aggr(Only({<Status = {'*Order*'}, UNITRATE = {'>0'}>} UNITRATE), ENQNO))