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

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
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
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: 
chibi
Creator
Creator
‎2021-10-07 02:01 AM

QlikSense avg expression error

Hi can anyone tell me where I'm going wrong with the expression? 

chibi_0-1633586477794.png

How do I resolve this? 

657 Views
0 Likes
2 Replies
MayilVahanan
MVP
MVP
‎2021-10-07 02:42 AM

HI

We can't use nested aggregation. 

Try like below

=Avg(Aggr(urexp, Dim))

https://help.qlik.com/en-US/sense/August2021/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/aggr.ht....

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
642 Views
chibi
Creator
Creator
‎2021-10-07 03:03 AM
Author

Now it shows this error

 

chibi_1-1633590228280.png

 

612 Views
0 Likes