Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
j_schmidt
Creator
Creator

Set Analysis question

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
)

 

 

 

 

Labels (1)
1 Solution

Accepted Solutions
rwunderlich

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

View solution in original post

4 Replies
joaopaulo_delco
Partner
Partner

Hi @j_schmidt !

 

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

I think what you trying to do is impossible.

 

j_schmidt
Creator
Creator
Author

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

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

View solution in original post

j_schmidt
Creator
Creator
Author

Great, thanks working, thanks a lot!