Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
D19PAL
Creator II
Creator II

Can you do an "or" in set analysis

Hi,

Can you do an 'or' like in an if statement in set analysis?

 

Thanks

 

1 Solution

Accepted Solutions
Andrei_Cusnir
Specialist
Specialist

Hello,

 

Can you please provide further context to the use case scenario? 

 

As an example here is a set analysis for counting all records with ID = 10: Count({<EmployeeID={10}>}EmployeeID) and here is a set analysis for counting all records where ID equals to 11: Count({<EmployeeID={11}>}EmployeeID). If you would like to count all records where ID is either 10 or 11 then you can use this set analysis: Count({<EmployeeID={10,11}>}EmployeeID).

 

This is the result that I get:

SCREENSHOT

As you can see, it has properly counted all the records, where the ID is either 10 or 11. 

 

Is this what you were looking for? 

Help users find answers! Don't forget to mark a solution that worked for you! 🙂

View solution in original post

1 Reply
Andrei_Cusnir
Specialist
Specialist

Hello,

 

Can you please provide further context to the use case scenario? 

 

As an example here is a set analysis for counting all records with ID = 10: Count({<EmployeeID={10}>}EmployeeID) and here is a set analysis for counting all records where ID equals to 11: Count({<EmployeeID={11}>}EmployeeID). If you would like to count all records where ID is either 10 or 11 then you can use this set analysis: Count({<EmployeeID={10,11}>}EmployeeID).

 

This is the result that I get:

SCREENSHOT

As you can see, it has properly counted all the records, where the ID is either 10 or 11. 

 

Is this what you were looking for? 

Help users find answers! Don't forget to mark a solution that worked for you! 🙂