Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Functions not working in Load Script

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

1 Solution

Accepted Solutions
giakoum
Partner - Master II
Partner - Master II

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.

View solution in original post

2 Replies
giakoum
Partner - Master II
Partner - Master II

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.

Not applicable
Author

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.