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

Error in expression ')' expected

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

Hai,

Load

Id,

qty,

Date

from (etc)

Max(Date) as maxdate

set vmax=floor(peek(maxdate));

if(programdate=Date or programdate=vmax,qty,0) as Qty

if i reload this script means it showing Error in expression ')' expected.why this error is coming..thanks in advance

Re: Error in expression ')' expected

sunny_talwar — Tue, 10 Jan 2017 10:52:12 GMT

Is this if statement withing a table load, right? not just sitting there all by itself?

LOAD BlahBlah,

if(programdate=Date or programdate=vmax,qty,0) as Qty

FROM ....

Re: Error in expression ')' expected

Anonymous — Tue, 10 Jan 2017 10:55:53 GMT

Sorry I forgot to tell.i just create resident table..in dt nly i have created if condition

Re: Error in expression ')' expected

annafuksa1 — Tue, 10 Jan 2017 11:07:55 GMT

Could you copy full script ? or the app ?

Here looks like wrong order.

Re: Error in expression ')' expected

Anonymous — Tue, 10 Jan 2017 11:20:05 GMT

LOAD

Max(programdate) as MaxDate

Resident 1;

LET vMaxDate = floor(peek('MaxDate'));

DROP Table A;

LOAD *,

if(((programdate=Date(Floor(MonthEnd(programdate))))or programdate=$(vMaxDate)),Quantity,0) as month_qty,

Resident 1;

DROP Table 1;

this is my script..bt it showing error

Re: Error in expression ')' expected

annafuksa1 — Tue, 10 Jan 2017 11:40:15 GMT

the problem is unnecessary ','

LOAD *,

if(((programdate=Date(Floor(MonthEnd(programdate))))or programdate=$(vMaxDate)),Quantity,0) as month_qty,

Resident 1;

DROP Table 1;

try

LOAD *,

if(((programdate=Date(Floor(MonthEnd(programdate))))or programdate=$(vMaxDate)),Quantity,0) as month_qty

Resident 1;

DROP Table 1;

Re: Error in expression ')' expected

Anonymous — Tue, 10 Jan 2017 11:43:16 GMT

sorry dt mistake made by me.in originally i am not putting ','.can u pls explain wht is d error in thz

Re: Error in expression ')' expected

sunny_talwar — Tue, 10 Jan 2017 11:51:38 GMT

How about this (tried to get rid of unnecessary parenthesis):

LOAD Max(programdate) as MaxDate

Resident 1;

LET vMaxDate = floor(peek('MaxDate'));

DROP Table A;

LOAD *,

If(programdate = Floor(MonthEnd(programdate)) or programdate = $(vMaxDate), Quantity, 0) as month_qty

Resident 1;

DROP Table 1;

Re: Error in expression ')' expected

Anonymous — Tue, 10 Jan 2017 11:54:47 GMT

Hai sunny..

i have tried ths,whtever i do it shows ths error nly.and also i can't view this table in table viewr.is ths a common error'a.???

Re: Error in expression ')' expected

annafuksa1 — Tue, 10 Jan 2017 11:55:55 GMT

sorry didn't understand your answer.

the mistake I point was that you put ',' in load script between dimension, in your script Qlikview thought that Resident is another field and there is no 'from/Resident' and that couse error.

second I think your calculation may be incorrect,

are you trying to calculate max quantity per month ?

Re: Error in expression ')' expected

sunny_talwar — Tue, 10 Jan 2017 11:56:22 GMT

Can you check your variable by adding a trace statement

LOAD Max(programdate) as MaxDate

Resident 1;

LET vMaxDate = floor(peek('MaxDate'));

TRACE $(vMaxDate);

EXIT SCRIPT;