How to not filter a Box Plot in Qlik Sense

[Eli181]

Hi. 

I have a table with accounts and respective sales transactions (i.e. several sales line items for a specific account).

I would like to compare each account in a box plot (that I know how to do), but also against the overall country average / quartiles, etc.

1. Can I illustrate this in the same chart ? This will be my preferred option. If not:
2. How can I illustrate in the same type of chart ?  I tried
   1. avg({$<Account=>}Sales for the measure, to eliminate the influence of the filter, but it still does not work.

Thank you for your help.

JM

[rwunderlich]

If Country is a dimension in your chart, you can use the TOTAL qualifier to "widen" your dimension like this:

avg({$<Account=>} TOTAL<Country> Sales)

https://help.qlik.com/en-US/sense/February2021/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/defin...

If Country if not in your chart, you will need to use Aggr() instead of TOTAL. 

aggr(avg({$<Account=>} Sales), Country)

if you have more than one Country linked to your chart dimension, you will need to add an outer aggregation to aggregate the multiple values. For example:

Avg(aggr(avg({$<Account=>} Sales), Country))

-Rob