Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Round Average Count Reference Line

Hi, 

I currently have this formula;

=Avg({1} Aggr(Count({1} ID), [Month]))

But I want the result average to be rounded to a whole number. How can I achieve this?

1 Reply
Highlighted
Creator
Creator

You can use the function Round()

https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Gene...

I think this is what you need
=Round(Avg({1} Aggr(Count({1} ID), [Month])))

I hope it helps!