Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

bjornklang
New Contributor

Avg of total sales if. chart

Hi

I'm working on an app but have unfortunatly got stuck in one place.

What I'm trying to achive is that Person7 in attached example gets the avarege amout of sales as the other persons.

Íf a person belongs in Department4, he should recieve the avarege amout of sales as the remaining persons. Would this be possible?

best regard.

/Björn

1 Solution

Accepted Solutions

Re: Avg of total sales if. chart

May be like this

If(Department = 4, Avg(TOTAL {<Department -= {'4'}>}Sales), Sales)

3 Replies

Re: Avg of total sales if. chart

May be like this

If(Department = 4, Avg(TOTAL {<Department -= {'4'}>}Sales), Sales)

bjornklang
New Contributor

Re: Avg of total sales if. chart

Thanks. That works great if the Sales column is found in the data file.

In my case the Sales collumn is an expression and "Sales" is the Label of the expression. For some reason I can't get it to work when using the Label.

Re: Avg of total sales if. chart

What is the expression?

Community Browser