topic Complex set analysis - dates. in QlikView https://community.qlik.com/t5/QlikView/Complex-set-analysis-dates/m-p/589145#M679349 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have to display a metric: number of items that have been in the database for over a year and don't have a review data or an owner.</P><P></P><P>These are the fields I need for it:</P><P>ItemID</P><P>Owner - owner of the item</P><P>PublishDate - when items was added</P><P>vToday - variable - todays date</P><P></P><P>I'm not sure how to tackle this. Any ideas?</P></BODY></HTML> Fri, 02 May 2014 11:14:46 GMT 2014-05-02T11:14:46Z Complex set analysis - dates. https://community.qlik.com/t5/QlikView/Complex-set-analysis-dates/m-p/589145#M679349 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have to display a metric: number of items that have been in the database for over a year and don't have a review data or an owner.</P><P></P><P>These are the fields I need for it:</P><P>ItemID</P><P>Owner - owner of the item</P><P>PublishDate - when items was added</P><P>vToday - variable - todays date</P><P></P><P>I'm not sure how to tackle this. Any ideas?</P></BODY></HTML> Fri, 02 May 2014 11:14:46 GMT https://community.qlik.com/t5/QlikView/Complex-set-analysis-dates/m-p/589145#M679349 2014-05-02T11:14:46Z Re: Complex set analysis - dates. https://community.qlik.com/t5/QlikView/Complex-set-analysis-dates/m-p/589146#M679351 <HTML><HEAD></HEAD><BODY><P>Count({&lt;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Owner</SPAN>=<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">{"=len(trim(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Owner</SPAN>))=0"},<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">PublishDate</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">={"$(= '&gt;=' &amp; date(</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">vToday</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">) &amp; '&lt;=' &amp; </SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">date(</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">vToday-365</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">)</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">)"}</SPAN></SPAN>&gt;}ItemID)</P></BODY></HTML> Fri, 02 May 2014 11:25:00 GMT https://community.qlik.com/t5/QlikView/Complex-set-analysis-dates/m-p/589146#M679351 anbu1984 2014-05-02T11:25:00Z Re: Complex set analysis - dates. https://community.qlik.com/t5/QlikView/Complex-set-analysis-dates/m-p/589147#M679353 <HTML><HEAD></HEAD><BODY><P>Provide some sample data please !</P></BODY></HTML> Fri, 02 May 2014 11:38:20 GMT https://community.qlik.com/t5/QlikView/Complex-set-analysis-dates/m-p/589147#M679353 MK_QSL 2014-05-02T11:38:20Z