Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

set analysis expression

need an expression as :

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

3 Replies
Highlighted

Re: set analysis expression

Not getting anything over here. IS this?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Specialist
Specialist

Re: set analysis expression

Hello, em... girl?

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

Highlighted
Champion II
Champion II

Re: set analysis expression

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