topic Set Analysis with Dates in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-with-Dates/m-p/287621#M106988 <HTML><HEAD></HEAD><BODY><P>That was it.&nbsp; I just fixed the date format and it worked.&nbsp; <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 15 Feb 2012 23:57:48 GMT 2012-02-15T23:57:48Z Set Analysis with Dates https://community.qlik.com/t5/QlikView/Set-Analysis-with-Dates/m-p/287619#M106986 <HTML><HEAD></HEAD><BODY><P>I have been loving the set analysis.&nbsp; It is really cool.&nbsp; I am doing this one by date but its not working.&nbsp; </P><P></P><P>=Sum({1&lt;lead_submitted_date = {"&gt;05/01/2012"}&gt;}num_leads_sold)</P><P></P><P>I want all records when the date is past 5/1/2012.&nbsp; What am I doing wrong?</P></BODY></HTML> Wed, 15 Feb 2012 22:15:49 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-Dates/m-p/287619#M106986 2012-02-15T22:15:49Z Set Analysis with Dates https://community.qlik.com/t5/QlikView/Set-Analysis-with-Dates/m-p/287620#M106987 <HTML><HEAD></HEAD><BODY><P>It's probably just a formatting mismatch. Have you double checked your lead_submitted_date format?</P><P>If you say, it is not working, what is your result? Zero, or a value that seems to be wrong?</P></BODY></HTML> Wed, 15 Feb 2012 23:42:31 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-Dates/m-p/287620#M106987 swuehl 2012-02-15T23:42:31Z Set Analysis with Dates https://community.qlik.com/t5/QlikView/Set-Analysis-with-Dates/m-p/287621#M106988 <HTML><HEAD></HEAD><BODY><P>That was it.&nbsp; I just fixed the date format and it worked.&nbsp; <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 15 Feb 2012 23:57:48 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-Dates/m-p/287621#M106988 2012-02-15T23:57:48Z