Set Analysis question

[schmidtj]

Hi,

i have a stupid question i think but here it goes:
The following SET ANALYSIS counts the IDs where name is either test OR test2.
I am wondering if there is a way to achieve that only the IDs are counted where name is test AND test2.
I know i could solve that problem somehow via the data script but i was hoping to do it with SA.

Thanks a lot.

Count
(
  {
    $<              
      [Name] = {'test', 'test2'}
    >
  }

  ID
)

[joaopaulo_delco]

Hi @schmidtj !

               How is possible the field name have "test" AND 'test2' value??

I think what you trying to do is impossible.

[schmidtj]

Hi,

well ok i dont mean the name of the field i mean the value of the field 'Name'.
It is basically a 1:n relation so 'Name' can have multiple values.

[rwunderlich · Accepted solution]

I think it's 

Count({ <ID=P({<Name={'test'}>})> * <ID=P({<Name={'test2'}>})> } ID) 

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[schmidtj]

Great, thanks working, thanks a lot!