If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have a script in data load and I would like to use a concatenated column in the where condition. What is the correct way of achieving this?
LOAD "code",LOAD "subcode",("code" & "subcode") as "summary"
[table]:SQL SELECT "code","subcode"
from table where summary not in ('A23','B21');
Ok, I just found out the syntax is quite similar to SQL. So for someone else that may have this question, a solution would be like this:
from table where ("code" || "subcode") not in ('A23','B21');
View solution in original post