topic Advanced Set Analysis - Nested Element functions P() in QlikView https://community.qlik.com/t5/QlikView/Advanced-Set-Analysis-Nested-Element-functions-P/m-p/287160#M499209 <HTML><HEAD></HEAD><BODY><P>Hello everyone</P><P></P><P>Im having a bit of a headache with conceptually understanding how to achieve an end goal.</P><P></P><P>I have attached a workbook which lists the progress so far.</P><P></P><P>It is essentially 'as of date' analysis</P><P></P><P>I wish to establish what the Volume Booked to travel on the Travel Equiv Date PY1 (D) was at equivalent points in time in history (E).&nbsp; </P><P></P><P>These points in time in history are based upon a calculation of selected Travel dates (A) and the max(Booking Date) of each of those dates (B).</P><P></P><P>I have tried several appraoches and feel that the manipulation must be made within the P() part of the expression associated with [Booking Date] but can not nail the syntax.</P><P></P><P>Any help would be greatly appreciated.</P><P></P><P>Regards</P><P></P><P>Fullbore_Moose</P></BODY></HTML> Tue, 14 Jun 2011 15:03:57 GMT 2011-06-14T15:03:57Z Advanced Set Analysis - Nested Element functions P() https://community.qlik.com/t5/QlikView/Advanced-Set-Analysis-Nested-Element-functions-P/m-p/287160#M499209 <HTML><HEAD></HEAD><BODY><P>Hello everyone</P><P></P><P>Im having a bit of a headache with conceptually understanding how to achieve an end goal.</P><P></P><P>I have attached a workbook which lists the progress so far.</P><P></P><P>It is essentially 'as of date' analysis</P><P></P><P>I wish to establish what the Volume Booked to travel on the Travel Equiv Date PY1 (D) was at equivalent points in time in history (E).&nbsp; </P><P></P><P>These points in time in history are based upon a calculation of selected Travel dates (A) and the max(Booking Date) of each of those dates (B).</P><P></P><P>I have tried several appraoches and feel that the manipulation must be made within the P() part of the expression associated with [Booking Date] but can not nail the syntax.</P><P></P><P>Any help would be greatly appreciated.</P><P></P><P>Regards</P><P></P><P>Fullbore_Moose</P></BODY></HTML> Tue, 14 Jun 2011 15:03:57 GMT https://community.qlik.com/t5/QlikView/Advanced-Set-Analysis-Nested-Element-functions-P/m-p/287160#M499209 2011-06-14T15:03:57Z