topic Set Analysis question in App Development

Set Analysis question

schmidtj — Wed, 24 Mar 2021 13:37:07 GMT

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 )

Re: Set Analysis question

joaopaulo_delco — Wed, 24 Mar 2021 14:23:22 GMT

Hi @schmidtj !

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

I think what you trying to do is impossible.

Re: Set Analysis question

schmidtj — Wed, 24 Mar 2021 14:31:57 GMT

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.

Re: Set Analysis question

rwunderlich — Wed, 24 Mar 2021 16:57:42 GMT

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

Re: Set Analysis question

schmidtj — Thu, 25 Mar 2021 08:33:37 GMT

Great, thanks working, thanks a lot!