Kindly help me to implement below code in qlikview
case when TT.BOOKING_TYPE in (0,14,21) then ( select DATE(FD.DEPARTURE_TIME) from TC_FLIGHTS_BOOK FLT, TC_FB_FLIGHT_DETAILS FD WHERE FLT.TC_FL_BOOKING_REF_NO=TT.BOOKING_REF_ID AND FLT.OID=FD.OID LIMIT 1 ) when TT.BOOKING_TYPE in (11) then ( select DATE(IR.JOURNEY_DATE) from TC_IR_BOOK IR WHERE IR.IR_REF_NO=TT.BOOKING_REF_ID LIMIT 1) when TT.BOOKING_TYPE in (1,17) then ( select DATE(HTL.CHECK_IN_DATE) from TC_HOTELS_BOOK HTL WHERE HTL.TC_HOTEL_BOOK_REF_ID=TT.BOOKING_REF_ID LIMIT 1) when TT.BOOKING_TYPE in (7) AND TT.BOOKING_REF_ID LIKE 'HO%' then ( select DATE(RT.JOURNEY_DATE) from TC_RT_BOOK RT WHERE RT.REF_ID=TT.BOOKING_REF_ID LIMIT 1 ) when TT.BOOKING_TYPE in (18) then ( select DATE(VI.TRAVEL_DATE) from TC_VISA_INVOICE_DETAILS VI, TC_VISA_INVOICE V WHERE V.VISA_BOOKING_REF_ID=TT.BOOKING_REF_ID AND V.OID=VI.OID LIMIT 1) when TT.BOOKING_TYPE in (7,9) then ( select DATE(HB.DEPARTURE_DATE) FROM TC_HOLIDAYS_BOOK HB WHERE HB.HLD_REF_ID=TT.BOOKING_REF_ID LIMIT 1) when TT.BOOKING_TYPE in (16) then ( select DATE(FX.DATE_OF_TRAVEL) FROM TC_FOREX FX WHERE FX.TC_FOREX_REF_NO=TT.BOOKING_REF_ID LIMIT 1) when TT.BOOKING_TYPE in (2) then (SELECT DATE(IB.DEPARTURE_DATE) FROM TC_INSURANCE_BOOK IB WHERE IB.IN_MSG_ID=TT.BOOKING_REF_ID LIMIT 1) ELSE 0 END AS TRAVEL_DATE,
