topic Script and text object acting differently?! Help! in QlikView

Script and text object acting differently?! Help!

Mon, 29 Apr 2013 22:31:08 GMT

I have an expression that seems to work in a text object but then doesn't when used in my script. Can someone suggest a solution and or explanation?

Problem:
I am trying to get a list delimited by ',' inside a variable so I can use it in some sql.

Here is the expression:

SET vMyVar =chr(39) & Concat(MY_FIELD, chr(39) & ', ' & chr(39)) & chr(39);

It blows up if you try to use LET instead of SET, but if it is copyed and pasted into a sheet object text it works fine...?

Thanks in advance for any help!

Mon, 29 Apr 2013 22:31:38 GMT

using LET gives "script object line error"

swuehl — Mon, 29 Apr 2013 22:57:06 GMT

You need to use aggregation functions in the context of a table LOAD.

Try using something like this:

TMP:

LOAD chr(39) & Concat(MY_FIELD, chr(39)&','&chr(39) ) & chr(39) as ConcatTmp

Resident TEST;

LET vMyVar = peek('ConcatTmp',-1,'TMP');

drop table TMP;

Assuming MY_FIELD field is originating in table TEST in this sample.

Mon, 29 Apr 2013 23:46:38 GMT

Thanks! It worked great!!!