Set Analysis Expression

[Anonymous]

Friends,

I have filters as in the screenshots below,

In customer listbox, the customer 'Addivant' has two mappings but other two customers has 1 mapping which is not common to the customer 'Addivant'.

When I click on Cargosmart, it should display Hapag customer (mapping matched with the selected customer) and vice-versa. If Addivant gets selected, nothing will be displayed in the text object, because it's mapping is not common to any customer.

Plz help me to create an expression for this, guys...

[sunny_talwar]

May be like this

Concat(DISTINCT {<Customer = e(Customer), Mapping = p(Mapping)>} Customer, ', ')

or

Concat(DISTINCT {<Mapping = p(Mapping)>} Customer, ', ')

[Anonymous]

Thanks Sunny, its working. But if I use this expression in the calculated dimension of a bar chart, its not working.

[sunny_talwar · Accepted solution]

You need to use the same set analysis in your expression.... don't really need to touch the dimension. Expression will take care of the dimension

{<Customer = e(Customer), Mapping = p(Mapping)>}

or this

{<Mapping = p(Mapping)>}

Whichever one worked, add it to your chart's expression

[Anonymous]

Thank you so much.. It's working.

[Anonymous]

Hi

If you must use the set analysis in the calculated dimension, use this expression

=Aggr(Only(<set expr> Customer),Customer)

set expr = whichever of the set expressions from Sunny's response is working for you.

Remember to supress null for the dimension.