0 Replies Latest reply: Jul 14, 2011 11:12 AM by tracycocco RSS

    Trying to qualify off a field from a different table

      Hi - Im having an issue with creating code in Qlikview for something that I could do easily in SQL.

       

      I have a table that contains data regarding patient orders. I want to find the patients location when the order was placed.

      I am dealing with a ORDERS table and ENOUNTER_LOC_HISTORY table.

       

      The ENCOUNTER_LOC_HISTORY table contains a row for each location the patient has occupied. It looks something like this

       

      ENCNTR_LOC_HIS_ID          ENCOUNTER_ID           BEG_EFFECTIVE_TIME       END_EFFECTIVE_TIME        LOCATION

      123                                               888888                     07/1/2011  0800                 07/1/2011   1400                     ED

          

      456                                               888888                     07/1/2011   1400                07/3/2011    0900                    ICU

       

      789                                               888888                     07/3/2011    0900               07/3/2011    1600                    A2

       

       

      The ORDERS table contains all orders

       

      ORDER_ID                    ENCOUNTER_ID                      ORDERNAME                       ORDER_TIME

      987                                       888888                                  WBC                                07/1/2011  1115

       

      654                                       888888                                Asprin                                07/2/2011   1200

       

       

       

       

      I ony want to pull the rows from the ENCOUNTER_LOC_HISTORY table where the

       

      ORDER_TIME is between the BEG_EFFECTIVE_TIME and END_EFFECTIVE_TIME.

       

      Im still somewhat new to Qlikview and this has stumped me.