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
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
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: 
Anonymous
Not applicable
‎2017-05-17 07:41 AM

set analysis expression

need an expression as :

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

Labels (1)
Labels
610 Views
0 Likes
3 Replies
Anil_Babu_Samineni
MVP
MVP
‎2017-05-17 07:43 AM

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
571 Views
Sergey_Shuklin
Specialist
Specialist
‎2017-05-17 07:47 AM

Hello, em... girl?

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

571 Views
vinieme12
Champion III
Champion III
‎2017-05-17 08:56 AM

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.
571 Views
0 Likes