topic Re: Functions not working in Load Script in QlikView

Functions not working in Load Script

Fri, 22 Feb 2013 10:41:25 GMT

Can someone give me a hint of why none of these functions are working in my load script?

LET Compfin = MakeDate(ANOACT,MESACT);

LET Compini = MonthStart(MakeDate(ANOACT,MESACT),-1);

After running the script, the variables Compfin and Compini are not even created.

Both expresions are returning the correct result if I use them in a text box object.

Thanks

giakoum — Fri, 22 Feb 2013 10:49:12 GMT

What are ANOACT,MESACT?

If they are data field names, you cannot quote them like this, you need to use Peek or FieldValue functions for example.

Fri, 22 Feb 2013 11:05:46 GMT

Upss! you are right. I was confused because there is only one record in the table. Will try Peek() to retrieve the contens of the fields.

Thanks.