topic Re: Event SE_LOG: Expression Error in QlikView

Event SE_LOG: Expression Error

infosense_devel — Tue, 02 May 2017 10:12:00 GMT

Hello,

when I am accessing my QVW file from access point one of my chart object give an error,

SE_LOG: Expression Error. Doc: 02.Published/O2C Analysis.qvw, ObjectId: Document\CH367, Expr(0)

From windows event viewer: Event id 300

Thanks in Advance...!

Re: Event SE_LOG: Expression Error

Anil_Babu_Samineni — Tue, 02 May 2017 10:18:32 GMT

Could be the cause Upgrade issue, Can i know the expression you used for that object 367??

Re: Event SE_LOG: Expression Error

infosense_devel — Tue, 02 May 2017 10:28:55 GMT

Please find below expression:

=Sum ({<REC_TYPE={GTNRec},ACCOUNT_GROUP={'Gross Sales'},GCC_SEGMENT3-={3801},Common_Year = {'$(vDSOEPriorYear)'},Common_Date = {'>=$(=min(AddMonths(=min(MonthStart(Common_Date)),-12))) <=$(=max(AddMonths(today()-1,-12)))'}>} RAGLDA_ACCTD_AMOUNT)

below is another expression which is not giving error in same chart:

=Sum ({<REC_TYPE={GTNRec},ACCOUNT_GROUP={'Gross Sales'},GCC_SEGMENT3-={3801},Common_Year = {'$(vDSOEMaxYear)'}>} RAGLDA_ACCTD_AMOUNT)

Re: Event SE_LOG: Expression Error

Anil_Babu_Samineni — Tue, 02 May 2017 12:08:26 GMT

I didn't understand this part at all. Could be issue over here. May be this?

Common_Date = {'>=$(=min(AddMonths(=min(MonthStart(Common_Date)),-12))) <=$(=max(AddMonths(today()-1,-12)))'}

Common_Date = {'>=$(=AddMonths(Min(MonthStart(Common_Date)),-12)) <=$(=Max(AddMonths(Today()-1,-12)))'}

Final Expression Should be this, May be

=Sum ({<REC_TYPE={'GTNRec'},ACCOUNT_GROUP={'Gross Sales'},GCC_SEGMENT3-={3801},Common_Year = {'$(vDSOEPriorYear)'}, Common_Date = {'>=$(=AddMonths(Min(MonthStart(Common_Date)),-12)) <=$(=Max(AddMonths(Today()-1,-12)))'} >} RAGLDA_ACCTD_AMOUNT)

Note: You may getting error like Nested Aggregation.