topic Re: Only({<[All Status]*={'A','B'}>}[All Status]) in QlikView

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

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

Hi All,

What is the meaning of this expression

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

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

vinieme12 — Fri, 29 Jul 2016 16:28:43 GMT

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

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

Anil_Babu_Samineni — Fri, 29 Jul 2016 16:41:22 GMT

Aretha,

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

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

trdandamudi — Fri, 29 Jul 2016 16:45:40 GMT

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