topic Re: OR Operator in QlikView

OR Operator

siddharthsoam — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: OR Operator

sunny_talwar — Fri, 14 Jul 2017 11:49:09 GMT

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

Re: OR Operator

siddharthsoam — Fri, 14 Jul 2017 12:12:07 GMT

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

Re: OR Operator

prma7799 — Fri, 14 Jul 2017 12:15:26 GMT

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

Re: OR Operator

vvvvvvizard — Fri, 14 Jul 2017 12:15:27 GMT

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

Re: OR Operator

sunny_talwar — Fri, 14 Jul 2017 12:16:53 GMT

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))

Re: OR Operator

arvind_patil — Fri, 14 Jul 2017 12:38:37 GMT

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