Only({<[All Status]*={'A','B'}>}[All Status])

[arethaking]

Hi All,

What is the meaning of this expression

Only({<[All Status]*={'A','B'}>}[All Status])

[vinieme12]

How to use - Only()

Set Analysis: syntaxes, examples

You can search for content using the search bar, you will find answer to most of your questions this way

[Anil_Babu_Samineni]

Aretha,

This expression getting only All Status Values where All Status is A & B

[trdandamudi]

You only want to show values for [All Status] ={A.B}. When you want to do this with set analysis, you need to aggregate it, but you can't without an aggregation function. So, fortunately, only() is an aggregation function, so you can write this as:

Only({<[All Status]*={'A','B'}>}[All Status])

Regarding the Intersection of the fields it is the same that has been explained in the following link:

https://community.qlik.com/thread/226311

Hope this helps...