Discussion board where members can get started with Qlik Sense.
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.
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.
if( Len(Trim([Date]))=0 and [Result]='Pass',Null(), ID)
Thanks for the response Cheenu. Unfortunately, its not working.
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.
try below by removing Null() May be it works
=if( Len(Trim([Date]))=0 and [Result]='Pass', ID)
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
Then the problem is latter in your script. Usually, error description doesn't refer to the actual line that it has happened
Try the below expression:
IF(ISNULL([Date]) AND [Result] = 'Pass', 'NULL', [ID])