topic Re: Expression Error in QlikView

Expression Error

rohitians — Thu, 02 May 2013 04:55:09 GMT

Hello everyone I have expression when i reload the script it shows the following error

Error in expression:

')' expected

I am not able to rectify it,

Please if you finf the error please help.

Error in expression:

')' expected

DIM_ProductBatchMaster:

LOAD

UPPER(PROD_BATCH) AS [Product Batch Code],

Fact_Type AS [Fact Type Code],

Fact_Type_Desc AS [Fact Type],

LocCode AS [Batch Location Code],

Loc_name AS [Batch Location],

Date(floor(MDATE),'DD/MM/YYYY') AS [Manufacturing Date],

Date(floor(EDATE),'DD/MM/YYYY') AS [Expiry Date],

Date(floor(EFFDATE),'DD/MM/YYYY') AS [Effective Date],

If(num(Date(floor(EDATE))-($(vDateForAgeing)))>=1 and num(Date(floor(EDATE))-($(vDateForAgeing)))<=30,'1-30',
if(num(Date(floor(EDATE))-($(vDateForAgeing)))>=31 and num(Date(floor(EDATE))-($(vDateForAgeing)))<=60,'31-60',
if(num(Date(floor(EDATE))-($(vDateForAgeing)))>=61 and num(Date(floor(EDATE))-($(vDateForAgeing)))<=90,'61-90',
if(num(Date(floor(EDATE))-($(vDateForAgeing)))>=91 and num(Date(floor(EDATE))-($(vDateForAgeing)))<=180,'91-180',
if(num(Date(floor(EDATE))-($(vDateForAgeing)))>=181,'181+',
if(num(Date(floor(EDATE))-($(vDateForAgeing)))<1 ,'Expired',
if(IsNull(date(EDATE)) OR Date(EDATE)='','Date NA'))))))) AS InvDaysSelection

vDateForAgeing=

=IF(ISNULL(GetFieldSelections($(vMonthName)))=0 OR ISNULL(GetFieldSelections($(vFinancialYear)))=0,DATE(MAX($(vPostingDate))),DATE(Today()))

Thanks and Regards,

Rohit

Re: Expression Error

sushil353 — Thu, 02 May 2013 05:18:25 GMT

Hi,

Try to put your variable value in quotes... since it is date data type..

If(num(Date(floor(EDATE))-('$(vDateForAgeing)'))>=1 and num(Date(floor(EDATE))-('$(vDateForAgeing)'))<=30,'1-30',
if(num(Date(floor(EDATE))-('$(vDateForAgeing)'))>=31 and num(Date(floor(EDATE))-('$(vDateForAgeing)'))<=60,'31-60',
if(num(Date(floor(EDATE))-('$(vDateForAgeing)'))>=61 and num(Date(floor(EDATE))-('$(vDateForAgeing)'))<=90,'61-90',
if(num(Date(floor(EDATE))-('$(vDateForAgeing)'))>=91 and num(Date(floor(EDATE))-('$(vDateForAgeing)'))<=180,'91-180',
if(num(Date(floor(EDATE))-('$(vDateForAgeing)'))>=181,'181+',
if(num(Date(floor(EDATE))-('$(vDateForAgeing)'))<1 ,'Expired',
if(IsNull(date(EDATE)) OR Date(EDATE)='','Date NA'))))))) ASInvDaysSelection

HTH

Sushil

Re: Expression Error

Thu, 02 May 2013 05:19:15 GMT

I check that your code,

here doesn't show any error.

Re: Expression Error

rohitians — Thu, 02 May 2013 07:44:31 GMT

Thanks For reply it was showing error..