If than based on selections

[cmenszak1]

I have a Qlik Sense app where I have dimensions for distributor name and distributor code plus one measure for sales.  I am trying to create a table that shows sales data using the distributor name when it is selected in the distributor name filter box or distributor code for the distributor names not selected.  I am using set analysis to show sales for all distributors regardless of the distributor name selections.  I need this to work if one or multiple distributor names are selected.

[Vegar]

I found it hard to pinpoint the core of your problem. Do you think you could post a sample of what you are trying to do? It should be easier to help you if you do so.

-Vegar

[cmenszak1]

I attached a sample Qlikview app. 

There is a chart in the app that I want to show the DistributorName for all selected in the DistributorName list box and the DistributorCode if the DistributorName is not selected.

[Vegar · Accepted solution]

Try an expression like this:

=AGGR(if( ONLY({1}DistributorName)=ONLY(DistributorName),
DistributorName,
ONLY({1}DistributorCode))
, DistributorName)

See attached QVW