2 Replies Latest reply: Mar 12, 2015 10:10 AM by Andreas Dippel RSS

    conditional load with filed from other table

      hi,
      is it possible to use a field from another (allready loaded) table in a load condition of another table ?
      its possible in sql, but how could it be done in qlikview script ?

      the table "customers" is loaded first.


      "customers" (customer_id, customer_area, subarea_code, customer_name)

      customer_area= city
      subarea_code= district/zipcode

       

       

      f.e. i want to load purchase histories from one table
      "sales" (order_id, order_date, order_amount, item_ID, customer_id)


      BUT only for customers who live in a certain area

       

      of course this could be done in the document with listboxes etc. But the huge amount of data from orders should be limited during load.

      i could  be usefull for other loads too, especiall with large amounts of data and distributed dependencies.