Discussion Board for collaboration related to QlikView App Development.
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
Date(+(Iterno()-1),'YYYYMMDD') as [Posting Date_BUDAT]
While Date(-109205+(Iterno()-1)) <=Date().
Script is as below :
Date($(vStartDate )+(Iterno()-1),'YYYYMMDD') as [Posting Date_BUDAT]
// Date, to be used as key field to transactions
While Date($(vStartDate)+(Iterno()-1)) <=Date($(vEndDate));
Please help me to resolve this error.
After doing the hardcoding of start date , its giving same error.
Let vStartDate = num(date('20140401','YYYYMMDD'));
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.
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: