Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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.

Community Browser