Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
siddharthsoam
Partner - Creator II
Partner - Creator II

OR Operator

Can someone help me on how to use OR operator in expressions?

1 Solution

Accepted Solutions
arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Siddharth,

If you trying to use it in Set Analysis you can use like below:

Sum({<Type-={"A"},Month-={"Jan","Feb"}>+<Type-={"A"},Month-={"Jan","Feb"}>}Sale)

Thanks

Arvind Patil

View solution in original post

6 Replies
sunny_talwar

Do I have a specific expression you want help with? I am not even sure what are you trying to learn here? An example of what you are looking might help

siddharthsoam
Partner - Creator II
Partner - Creator II
Author

For example if I want to count the employee id of people who work in finance or sales department. How would I do it

prma7799
Master III
Master III

= Count({<Dept = {'finance' , 'sales'} >}EmployeeId)

vvvvvvizard
Partner - Specialist
Partner - Specialist

if(Color='red' or Color='blue'  or Color='green', 'Its a primary color ' , 'Not a primary color ')

sunny_talwar

this would be the set analysis way

Count({<Dept = {'Finance', 'Sales'}>}EmployeeID)

If statement

Count(If(Match(Dept, 'Finance', 'Sales'), EmployeeID))

Count(If(Dept = 'Finance' or Dept = 'Sales', EmployeeID))

arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Siddharth,

If you trying to use it in Set Analysis you can use like below:

Sum({<Type-={"A"},Month-={"Jan","Feb"}>+<Type-={"A"},Month-={"Jan","Feb"}>}Sale)

Thanks

Arvind Patil