topic Re: If Statements in QlikView

If Statements

Wed, 25 Nov 2020 16:16:04 GMT

HI I am new to Qlikview. i am setting up my project.

i need to put if statement in my condition like this;

If(WorkerType='Employee', AND(EmployeeType='Regular','Probationary',),1,0)

how to write this condition in Qlikview.

Thanks.

Re: If Statements

tamilarasu — Thu, 28 Apr 2016 06:52:59 GMT

Try,

If(WorkerType='Employee' And Match(EmployeeType='Regular','Probationary'),1,0)

If(WorkerType='Employee' And Match(EmployeeType, 'Regular','Probationary'),1,0)

Sorry for the typo error.

Re: If Statements

Thu, 28 Apr 2016 07:18:14 GMT

Hi Nagaraj Thanks !!

I tried but it gives me 0 Values. any reason why? i will explain what i need;

I have two type like 1st Worker Type :- Employee or Contingent Worker

then in sub category i have Employee Type :- Regular, Probationary, Fixed Term Contract.

for Employee HC i have to put both condition like Worker Type should be only Employee and Employee type should be Regular and Probationary to get exact Employee count.

Re: If Statements

pooja_sn — Thu, 28 Apr 2016 07:19:15 GMT

If(match(WorkerType,'Employee') AND match(EmployeeType,'Regular','Probationary',) ,1,0)

Re: If Statements

Anonymous — Thu, 28 Apr 2016 07:27:53 GMT

Hi Srikant,

Hope this will work.....

if((WorkerType='Employee' and Match(EmployeeType,'Regular','Probationary')>0,1,0)

Regards

Nitin

Re: If Statements

Thu, 28 Apr 2016 07:47:49 GMT

you can Use Either of the two :

If (WorkerType='Employee' and (EmployeeType='Regular' or EmployeeType='Probationary') ,1,0)

If(WorkerType='Employee' And Match(EmployeeType, 'Regular','Probationary'),1,0)

Regards,

Anjali Gupta

Re: If Statements

Anonymous — Thu, 28 Apr 2016 08:05:49 GMT

Use mixmatch, it will work too..

if((WorkerType='Employee' and MixMatch(EmployeeType,'Regular','Probationary')>0,1,0)

Re: If Statements

Thu, 28 Apr 2016 08:57:32 GMT

Thanks Anjali it works! second option...

Re: If Statements

Thu, 28 Apr 2016 08:58:00 GMT

Thanks it works

Re: If Statements

Fri, 29 Apr 2016 06:57:57 GMT

Good to know.. That it helped you..!!