Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sashokku
Contributor

If/And condition

Am trying to get the ID numbers where Date field should be empty and result field should be Pass. I am trying to do this within Data Manager.

if([Date]='Null' and [Result]='Pass','Null', ID)

Getting error near the ' ) ' .  Can someone help me out.

Thanks,

SAK

Tags (3)
8 Replies
cheenu_janakira
Contributor

Re: If/And condition

Hi Santosh,

Unless 'null' is the string in the cells in the column, have you tried "IF(ISNULL(Date) AND Maxstring(Result) = 'Pass', NULL(), ID)"? or otherwise alternatives around the functions being called for in the "if" statement.

Kr,

Cheenu

sasiparupudi1
Honored Contributor III

Re: If/And condition

if( Len(Trim([Date]))=0 and [Result]='Pass',Null(), ID)

sashokku
Contributor

Re: If/And condition

Thanks for the response Cheenu. Unfortunately, its not working.

sashokku
Contributor

Re: If/And condition

Thanks for the response @Sasidhar Parupudi. Its not working though.

Adding to this, the same 'if' condition was working in direct data load. If I try to do the same in qvd, I am unable to do.

arunaerra
Contributor

Re: If/And condition

Hi

try below  by removing Null()  May be it works

like below

=if( Len(Trim([Date]))=0 and [Result]='Pass', ID)

chinnuchinni
Contributor III

Re: If/And condition

try this :

load ID,Date(Date) as Date,Result,


if(len(Trim((Date)))=0 and Result = 'Pass' ,ID) as empty_date_ID


;

LOAD * INLINE [

    ID, Date, Result

    1, 1/1/2017, Pass

    2, 1/2/2018, Fail

    3, 1/3/2017, Pass

    4, , Pass

    5, 3/4/2018, Fail

    6, , Pass

];



300542.PNG

ckarras22
New Contributor III

Re: If/And condition

Hi,

Then the problem is latter in your script. Usually, error description doesn't refer to the actual line that it has happened

sumitkulkarni
New Contributor III

Re: If/And condition

Hi Santhosh,

Try the below expression:

IF(ISNULL([Date]) AND [Result] = 'Pass', 'NULL', [ID])

Thank you!

Best Regards,

Sumit K

Community Browser