Discussion Board for collaboration on QlikView Scripting.
How can i adjust my load script to ensure the recorded without an AccountId are NOT loaded
Both these expressions kick up errors. What exactly am I doing wrong?
WHERE NOT IsNull(AccountId);
Go to Solution.
For Not Null, try this
WHERE AccountId != NULL;
You can try
WHERE IsNull(AccountId) = false() OR len(trim(AccountId))>0;
Both on the where.
Where IsNull(AccountId) <> -1
Upon testing the:
Where IsNull(AccountID) <> -1
seemed to work for me.
Didn't work. Got the error
"Invalid aggregate function IsNull"
"Invalid aggregate function: IsNull"
Is this criterion in a SQL SELECT statement?
SQL SELECT ......
This does not work because this statement is executed on the database server, not by QV. Translate the statement to the SQL dialect of your server; eg for MS SQLS
WHERE AccountId IS NOT NULL;
Can you post entire script
Could you paste your load here?
Yeah, as jonathan said, if you are executing this in SQL this will definitely not work.