Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
What is the meaning of this expression
Only({<[All Status]*={'A','B'}>}[All Status])
Set Analysis: syntaxes, examples
You can search for content using the search bar, you will find answer to most of your questions this way
Aretha,
This expression getting only All Status Values where All Status is A & B
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...