Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Kaushik2020
Creator III
Creator III

How to calculate Average

Hello Everyone, 

I am trying to calculate average for below values shown in the bar chart. 

i.e. Sum of Values shown on chart / no of days (i.e. 30)

kaushi2020_0-1696944934068.png

 

Labels (5)
2 Replies
Mark_Little
Luminary
Luminary

Hi,

Should be just be something like

Current set analysis / Count(Days)

If you share a little information like current Set analysis and dimension names maybe able to suggestion a little more detailed answer

Kaushik2020
Creator III
Creator III
Author

Thanks for your reply. here when we don't have a dimension and we calculate QlikSense calculates all distinct numbers and then divide by the count(Days).

(Count({$<Year=, Month=, Day=,Contact_Center={'121'},
Date={">=$(=date(monthstart(max(Date))))<=$(=date(max(Date)))"}>}
Distinct AgentID))

 

using above expression those value labels are calculated (as shown in the image - bar chart). 

Expectation - sum of those numbers which are shown as labels / count (Days)

Is that really possible ?