Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

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
Highlighted
Master
Master

Re: Code convert to SQL

Highlighted
Creator III
Creator III

Re: Code convert to SQL

Hi Vijay,

Paste following before your SQL statement in qlikview edit script.

tablename:

LOAD 

  *  ;

  SQL

Select