Discussion Board for collaboration on QlikView Scripting.
I want that my raport don't show any values if on of fields value is null?
I know how I do it in tables expression. But can I confine it in edit script? Then I do not need to do it in every table...
In SQL it is
WHERE fieldName IS NOT NULL;
How I can Do it in QlikView?
I think best way is something like that :
LOAD*FROM tableNameWHERE len(trim(fieldName))>0;
However, you can try with one of thoses solutions, but functions won't be understand as well, depend on your system.
First solution :
LOAD *FROM TableNameWERE fieldName = null();
WERE fieldName = null();
LOAD *FROM tableNameWHERE IsNull(fieldName)=False();
Hope that helps you
Nice explanation that is correct way i find it works for my scenario thanks.
I'm happy to help you !
But... in my situation it don't works
you can also try it with:
LOAD *FROM tableNameWHERE NOT IsNull(fieldName);