2 Replies Latest reply: Aug 22, 2013 7:31 PM by Rakesh Mehta RSS

    Joining with BEGDA ENDDA combinations

    David Foster

      Hi there

       

      I am brand new to working with QlikView and SAP. I am familiar with both individually, but not together.

       

      I am looking to create a starschema model within QlikView based on timesheet data in SAP. The challenge I have got is the complex join in SAP to link the timesheet data to the personnel record (P001)

       

      The join is the based on PERNR and then finding the P001 record with a BEGDA before the timesheet date and an ENDDA more or equal to the timesheet date. This is easy to code in SQL (if horribly expensive to process), but in QlikView I am confused on the best approach for resolving this join.

       

      Any thoughts/ideas/suggestions would be appreciated.