topic Re: If condition not working in QlikView

If condition not working

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am my below mentioned issue from long time but couldnt able to get solution on this.

Pls help me to solve.

Below is my sample data.

Data:

Requirement:

I need to show my data in above way.

I am using if but it is not working .

if(Applicant_status='A','Yes','No') .

Can anybody help me with this. This is very urgent .

sunny_talwar — Thu, 13 Oct 2016 15:26:42 GMT

Check this link out:

Anonymous — Thu, 13 Oct 2016 15:30:06 GMT

If (Applicant_status<>"" and Status_Date_Time="","NO","YES")

rupamjyotidas — Thu, 13 Oct 2016 15:32:52 GMT

Seems to be working

if(Applicant_status='A','Yes','No') as StatusFlag

Can you provide more explanation on what you are trying to achieve

vcanale — Thu, 13 Oct 2016 16:01:30 GMT

Hi,
Try:

if((Applicant_Id=1 AND Applicant_status<>'' AND Status_Date_Time<>'')

OR(Applicant_Id=2 AND Applicant_status<>'' AND Status_Date_Time<>''), 'Yes', 'NO')

albertovarela — Thu, 13 Oct 2016 17:04:49 GMT

Please see attached qvw