topic Re: Error in expression ')' expected in QlikView

Error in expression ')' expected

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Anonymous — Wed, 04 Jan 2017 12:47:48 GMT

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 — Wed, 04 Jan 2017 12:52:40 GMT

What is the error you are seeing?

marcus_sommer — Wed, 04 Jan 2017 13:50:15 GMT

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