HI I am new to Qlikview. i am setting up my project.
i need to put if statement in my condition like this;
how to write this condition in Qlikview.
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.
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)