Discussion Board for collaboration on QlikView Scripting.
I have a field , from a SQL database that I would like to IF against :
If (fieldname NOT NULL, do this )
How would I write this like above, but correctly ?
Go to Solution.
if( isNull('Fieldname'),'null conditon','not null conditon');
This will work..
try below code:
If(not isnull(filedname) ,1,0)
If( IsNull(fieldname) = 0, do this )
If( Not IsNull(fieldname), do this )
=if (not isnull(Plant_ShortName),Plant_ShortName & ' - ' & Plant_FullName)
If (IsNull(fieldname> <> -1, 'do this' )
Thanks , that worked perfectly !