If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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.
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 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