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.