Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

set analysis expression

need an expression as :

Avg (field) used (percustomer) (value) based on one (field)

3 Replies
Anil_Babu_Samineni

Not getting anything over here. IS this?

Avg({<percustomer = {'value'}>}field)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Sergey_Shuklin
Specialist
Specialist

Hello, em... girl?

You can also try this avg(aggr(sum(value),field))

vinieme12
Champion III
Champion III

NOt sure what exactly? but think the TOTAL Keyword will work for you

AVG(  TOTAL  <Country>     Sales)        <<  will give you total by each country ignoring other dimensions in chart

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