9 Replies Latest reply: Oct 16, 2012 5:54 AM by Steve Crosby RSS

    Data Modelling Issue

    Steve Crosby

      Hi All

       

      I am having difficulty in mapping some data into QlikView and wondered if anyone could help, please

       

      Basically I have 5 tables in SQL database that contain Customers, Price Lists, Rebate Header, Rebate Detail and Invoices.

      My challenge is this Customers can have Rebates the rate of which is held in the Rebate Header, for Products maintained on the Price List, UNLESS a Product is maintained in the Rebate Detail table in which case that rebate rate is used.

       

      I've attached an xlsx that represents some sample data.