Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
milindnikumbh
New Contributor III

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

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.

9 Replies

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

Hi,

It is because your variable has not got any value.

vStartDate


Check the variable assignment.


Regards,

Kaushik Solanki

milindnikumbh
New Contributor III

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

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

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

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.

milindnikumbh
New Contributor III

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

Hello ,

Still not working . same error.

Please suggest.

Regards,

Milind.

Highlighted
milindnikumbh
New Contributor III

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

Not resolved. Still error.

shuaibmoolla
New Contributor

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

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

shuaibmoolla
New Contributor

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

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

milindnikumbh
New Contributor III

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

Resolved.