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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Error in expression ')' expected

LET vMaxDateZ = floor(peek('MaxDateZ'));

if((program_date=date(floor(monthend(program_date)))) or (program_date=$(vMaxDateZ)),Qty,0) as qty.

I have created variable..it shows the error in variable nly.during reload..y and how to rectify this.but the exp is ok

.pls anyone help me thnks in advnce.

3 Replies
Anonymous
Not applicable
Author

Hi,

The field MaxDateZ is loaded before LET? I am getting the same error only when is not a field name in the application or when the variable is first.


Best regards,

Cosmina

sunny_talwar

What is the error you are seeing?

marcus_sommer

You are missing the record and the tablename within the peek-function - it should look like:

floor(peek('MaxDateZ', 0 /* maybe also -1 */, 'YourTable'))

then if you used peek outside from a load those parameter are mandatory.

- Marcus