topic Re: Set Analysis Expression in QlikView

Set Analysis Expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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...

Re: Set Analysis Expression

sunny_talwar — Thu, 06 Apr 2017 13:51:12 GMT

May be like this

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

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

Re: Set Analysis Expression

Anonymous — Thu, 06 Apr 2017 14:11:30 GMT

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

Re: Set Analysis Expression

sunny_talwar — Thu, 06 Apr 2017 14:15:41 GMT

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

Re: Set Analysis Expression

Anonymous — Thu, 06 Apr 2017 15:03:33 GMT

Thank you so much.. It's working.

Re: Set Analysis Expression

Anonymous — Thu, 06 Apr 2017 15:04:16 GMT

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.