topic Re: Subset of Data using conditions in QlikView https://community.qlik.com/t5/QlikView/Subset-of-Data-using-conditions/m-p/549627#M1133413 <HTML><HEAD></HEAD><BODY><P>Try creating an example with data that also explains and shows what the result should be. See this document:</P><P><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-1290" style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3778c7;">Preparing examples for Upload - Reduction and Data Scrambling</A></P></BODY></HTML> Wed, 30 Oct 2013 17:59:28 GMT Gysbert_Wassenaar 2013-10-30T17:59:28Z Subset of Data using conditions https://community.qlik.com/t5/QlikView/Subset-of-Data-using-conditions/m-p/549626#M1133412 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a data set and I am looking to extract records where the following paramaters are the same:</P><P></P><P>CONTRACT_DT</P><P>DESK_CD</P><P>OFFICE_CD</P><P>CONTRACT_QTY</P><P></P><P>The data should then be matched by Buy/Sell being opposite (ie Buy with Sell and Sell with Buy) and also where the PERIOD_CD is different.</P><P></P><P>I thought about creating an INDEX for the first part, however I am unsure how to approach the second part.</P><P></P><P>The aim is to calculate the net position of a data set and then remove trades where the above conditions are met and then re-calculate the net position.</P><P></P><P>Any help/ideas will be much appreciated.</P><P></P><P>Regards,</P><P>Daniel</P></BODY></HTML> Wed, 30 Oct 2013 17:21:20 GMT https://community.qlik.com/t5/QlikView/Subset-of-Data-using-conditions/m-p/549626#M1133412 danielnevitt 2013-10-30T17:21:20Z Re: Subset of Data using conditions https://community.qlik.com/t5/QlikView/Subset-of-Data-using-conditions/m-p/549627#M1133413 <HTML><HEAD></HEAD><BODY><P>Try creating an example with data that also explains and shows what the result should be. See this document:</P><P><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-1290" style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3778c7;">Preparing examples for Upload - Reduction and Data Scrambling</A></P></BODY></HTML> Wed, 30 Oct 2013 17:59:28 GMT https://community.qlik.com/t5/QlikView/Subset-of-Data-using-conditions/m-p/549627#M1133413 Gysbert_Wassenaar 2013-10-30T17:59:28Z