topic Re: IF WITH AND AND OR in QlikView

IF WITH AND AND OR

rammarthi — Sat, 16 Nov 2024 03:40:38 GMT

Hi,

I have three regions EU, AP and NA and two employee types PERM and TEMP.

Now if Employee type is Perm and Region is EU or AP then we should get X

if Employee type is Perm and Region is EU or AP or NA then we should get Y

if Employee type is Temp then we should get Z.

Can some one provide a possible if condition for this in front end in a text box.

Thanks in Advance

Re: IF WITH AND AND OR

rubenmarin — Sun, 05 May 2019 10:25:02 GMT

Hi, if you can assign only X, Y or Z, you need to review the conditions for Y, if type is perm and region is EU or AP, it's X and Y?, anyway, it could be something like
If(EmpType='TEMP', 'Z',
If(Match(Region,'EU','AP'), 'X', 'Y'))

Re: IF WITH AND AND OR

rammarthi — Tue, 07 May 2019 15:14:33 GMT

It can be solved this way: where SR is Special Region

If([Emp Type] = 'Perm',
If(Concat(Distinct SR) = 'APEUNA' or Concat(Distinct SR) = 'APNA' or Concat(Distinct SR) = 'EUNA' or Concat(Distinct SR) = 'NA' , 'Y',
If(Concat(Distinct SR) = 'APEU'or Concat(Distinct SR) = 'EU' or Concat(Distinct SR) = 'AP' , 'X') ),
'Z')

Re: IF WITH AND AND OR

rubenmarin — Tue, 07 May 2019 15:27:25 GMT

That's a different condition, finally you are asking if region has NA, in that case is Y. If doesn't have NA but has AP or EU then is X.