topic Re: QlikStart for SAP FI-GL (General Ledger) : Posting date error in QlikView

QlikStart for SAP FI-GL (General Ledger) : Posting date error

milindnikumbh — Mon, 29 Jan 2018 08:13:14 GMT

Dear Experts ,

I have successfully build QVD but not able to load the data to QVF file.

I am getting the the following error.

Error in expression:

Date takes 1-2 parameters

Load

Date(+(Iterno()-1),'YYYYMMDD') as [Posting Date_BUDAT]

Autogenerate 1

While Date(-109205+(Iterno()-1)) <=Date().

Script is as below :

Load

Date($(vStartDate )+(Iterno()-1),'YYYYMMDD') as [Posting Date_BUDAT]

// Date, to be used as key field to transactions

Autogenerate 1

While Date($(vStartDate)+(Iterno()-1)) <=Date($(vEndDate));

Please help me to resolve this error.

Best Regards,

Milind.

Re: QlikStart for SAP FI-GL (General Ledger) : Posting date error

kaushiknsolanki — Mon, 29 Jan 2018 08:28:13 GMT

Hi,

It is because your variable has not got any value.

vStartDate

Check the variable assignment.

Regards,

Kaushik Solanki

Re: QlikStart for SAP FI-GL (General Ledger) : Posting date error

milindnikumbh — Mon, 29 Jan 2018 08:40:07 GMT

Hi ,

After doing the hardcoding of start date , its giving same error.

Let vStartDate = num(date('20140401','YYYYMMDD'));

Regards,

Milind.

Re: QlikStart for SAP FI-GL (General Ledger) : Posting date error

kaushiknsolanki — Mon, 29 Jan 2018 08:44:04 GMT

Try this.

Let vStartDate = num(Makedate(2014,01,01));

Same for the enddate.

Regards,

Kaushik Solanki

Re: QlikStart for SAP FI-GL (General Ledger) : Posting date error

Peter_Cammaert — Mon, 29 Jan 2018 09:04:23 GMT

In your example, you are using a formatting function for interpretation of a date in an irregular format. That won't work.

Use Date#() instead. That's the one that does date parsing and interpretation.

Re: QlikStart for SAP FI-GL (General Ledger) : Posting date error

milindnikumbh — Mon, 29 Jan 2018 10:33:27 GMT

Hello ,

Still not working . same error.

Please suggest.

Regards,

Milind.

Re: QlikStart for SAP FI-GL (General Ledger) : Posting date error

milindnikumbh — Mon, 29 Jan 2018 10:33:50 GMT

Not resolved. Still error.

Re: QlikStart for SAP FI-GL (General Ledger) : Posting date error

Leo_M — Tue, 20 Mar 2018 09:29:19 GMT

Hi, I am receiving the exact same error. Kindly advise if you have found a solution to this issue. Much appreciated.

Re: QlikStart for SAP FI-GL (General Ledger) : Posting date error

Leo_M — Tue, 20 Mar 2018 11:14:50 GMT

Hi,

I've found a solution to the problem.

The problem was that it's was not loading data into BSEG_Document_Segment. You need to change your chart of account code.

Please see the thread below:

SAP FI - General Ledger QlikStart Template

Re: QlikStart for SAP FI-GL (General Ledger) : Posting date error

milindnikumbh — Wed, 21 Mar 2018 10:03:57 GMT

Resolved.