Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Code convert to SQL

Dear All,

Can anyone help me out I want to convert this Navision code to SQL

I want to create Customer receivable report.

CASE AgingBy OF

  AgingBy::"Due Date":

    PeriodIndex := GetPeriodIndex(CustLedgEntryEndingDate."Due Date");

  AgingBy::"Posting Date":

    PeriodIndex := GetPeriodIndex(CustLedgEntryEndingDate."Posting Date");

  AgingBy::"Document Date":

  BEGIN

    IF CustLedgEntryEndingDate."Document Date" > EndingDate THEN BEGIN

      CustLedgEntryEndingDate."Remaining Amount" := 0;

      CustLedgEntryEndingDate."Remaining Amt. (LCY)" := 0;

      CustLedgEntryEndingDate."Document Date" := CustLedgEntryEndingDate."Posting Date";

    END;

    PeriodIndex := GetPeriodIndex(CustLedgEntryEndingDate."Document Date");

  END;

END;

Or

How to connect Navision front end to qlikview ?

2 Replies
adamdavi3s
Master
Master

Anonymous
Not applicable
Author

Hi Vijay,

Paste following before your SQL statement in qlikview edit script.

tablename:

LOAD 

  *  ;

  SQL

Select