topic Query Analysis in QlikView https://community.qlik.com/t5/QlikView/Query-Analysis/m-p/354843#M131705 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Can anyone explain following query with example in qlikview</P><P></P><P>(select replace(concat(' ',cast(timestamp as varchar(19))),'-','/') </P><P>from pos.pos_audit_trail </P><P>where log_id =</P><P> (select max(log_id) </P><P>from pos.pos_audit_trail </P><P>where task_name like 'POS_OM_OrderBooking' </P><P>and bpm_order_id = p.bpm_order_id and task_event='COMPLETE') </P><P>and log_id&gt;</P><P>(select max(log_id) </P><P>from pos.pos_audit_trail</P><P> where task_name like 'POS_OM_OrderBooking' </P><P>and bpm_order_id = p.bpm_order_id </P><P>and (task_event='INITIATE' or task_event='CLAIM')))</P></BODY></HTML> Fri, 15 Jun 2012 12:28:16 GMT 2012-06-15T12:28:16Z Query Analysis https://community.qlik.com/t5/QlikView/Query-Analysis/m-p/354843#M131705 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Can anyone explain following query with example in qlikview</P><P></P><P>(select replace(concat(' ',cast(timestamp as varchar(19))),'-','/') </P><P>from pos.pos_audit_trail </P><P>where log_id =</P><P> (select max(log_id) </P><P>from pos.pos_audit_trail </P><P>where task_name like 'POS_OM_OrderBooking' </P><P>and bpm_order_id = p.bpm_order_id and task_event='COMPLETE') </P><P>and log_id&gt;</P><P>(select max(log_id) </P><P>from pos.pos_audit_trail</P><P> where task_name like 'POS_OM_OrderBooking' </P><P>and bpm_order_id = p.bpm_order_id </P><P>and (task_event='INITIATE' or task_event='CLAIM')))</P></BODY></HTML> Fri, 15 Jun 2012 12:28:16 GMT https://community.qlik.com/t5/QlikView/Query-Analysis/m-p/354843#M131705 2012-06-15T12:28:16Z