Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.
I have these fields in a table
i would like to create a field base in the two fields :
Field 3 is when I have Code_file with a Num_dos Null or empty
how to do this
Go to Solution.
if(len(trim(Code_file))>0 AND len(trim(Num_dos))=0, 'THEN', 'ELSE') as FIELD_3;
Hi Zied, this can be done in script or using Data Manager to create a calculated field if script is synchronized, the expression can be:
If(not IsNull(Code_file) and IsNull(Num_dos), 'ValueForTrue', 'ValueForFalse') as Field3
Edit: better use the Len(Trim()) option to handle empty values.