Skip to main content

Qlik

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
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
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: 
eprehu
Contributor III
Contributor III
‎2022-05-31 04:40 AM

Avg and count

Bonjour,

J'aimerais faire une moyenne de ce comptage ci dessous : 

eprehu_0-1653986351741.png

Comment ajouter un avg and un count() ? 

Merci !

Labels (1)
Labels
352 Views
0 Likes
4 Replies
Taoufiq_Zarra
MVP
MVP
‎2022-06-02 04:05 AM

@eprehu  normalement c'est un Aggr avec ta fonction

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
326 Views
0 Likes
vinieme12
Champion III
Champion III
‎2022-06-02 05:26 AM

Syntax as below

 

= AVG ( AGGR (

YourCountExpression

, Dimension1,Dimension2,...)  )

 

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
317 Views
0 Likes
eprehu
Contributor III
Contributor III
‎2022-06-02 05:56 AM
Author

In response to vinieme12

Thanks but i don't know which dimension i need to use

310 Views
0 Likes
vinieme12
Champion III
Champion III
‎2022-06-02 08:12 AM

In response to eprehu

The dimensions that are being used in the chart

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
305 Views
0 Likes