Exists() is a qlikview function; can't be executed in SQL. You should rather try directly the SQL statement (with IN ). Qlikview sends the sql statement to SQL engine in the dbms and it's get executed there. Hence, you can use the SQL statement as it is directly here in qv.
Thanks for your reply, I tried before In function only in the sql statement, the
When I copy from the CCC value in excel file and paste in the qv script, I am getting the following error, and when I manually key the numbers in the qv script its working fine, I don't know where I making mistake.
Token œ was not valid. Valid tokens: ( + - ? : DAY INF NAN RID ROW RRN CASE CAST CHAR DATE DAYS HASH.