topic Re: Set Analysis with Dates in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-with-Dates/m-p/1230060#M392012 <HTML><HEAD></HEAD><BODY><P>nwEVENTDTE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Net Sold Qty&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; XXX</P><P>10/13/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (this is what I want to solve for in an expression&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8/18/2016</P></BODY></HTML> Tue, 07 Feb 2017 21:14:46 GMT evansabres 2017-02-07T21:14:46Z Set Analysis with Dates https://community.qlik.com/t5/QlikView/Set-Analysis-with-Dates/m-p/1230058#M392010 <HTML><HEAD></HEAD><BODY><P>I have a field called 'nwEVENTDTE' (the event date) and another field called 'XXX' (the event date minus 56 days)</P><P></P><P>I have another field called [Net Sold Qty]. I have created a chart that uses the nwEVENTDTE as the dimension and what I want to do is to create an expression that gives me the [Net Sold Qty] for nwEVENTDTE - 'XXX'?</P><P></P><P>Is this possible?</P></BODY></HTML> Tue, 07 Feb 2017 20:58:43 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-Dates/m-p/1230058#M392010 evansabres 2017-02-07T20:58:43Z Re: Set Analysis with Dates https://community.qlik.com/t5/QlikView/Set-Analysis-with-Dates/m-p/1230059#M392011 <HTML><HEAD></HEAD><BODY><P>If you are asking how a set analysis can be evaluated in the context of a dimension, then have a look at this discussion</P><P><A href="https://community.qlik.com/docs/DOC-1335">Evaluating "sets" in the context of a dimension</A></P><P></P><P>If you are asking for something else, then please post some sample lines of data and a description of your model and your expected result.</P></BODY></HTML> Tue, 07 Feb 2017 21:10:56 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-Dates/m-p/1230059#M392011 swuehl 2017-02-07T21:10:56Z Re: Set Analysis with Dates https://community.qlik.com/t5/QlikView/Set-Analysis-with-Dates/m-p/1230060#M392012 <HTML><HEAD></HEAD><BODY><P>nwEVENTDTE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Net Sold Qty&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; XXX</P><P>10/13/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (this is what I want to solve for in an expression&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8/18/2016</P></BODY></HTML> Tue, 07 Feb 2017 21:14:46 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-Dates/m-p/1230060#M392012 evansabres 2017-02-07T21:14:46Z