topic Re: Extract set of Dates in App Development https://community.qlik.com/t5/App-Development/Extract-set-of-Dates/m-p/1406809#M32905 <HTML><HEAD></HEAD><BODY><P>May be you can just do this</P><P></P><P><STRONG>LOAD Date,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; If(Date &gt;= MakeDate(2016), Date) as NewDateColumn</STRONG></P><P><STRONG>FROM ...</STRONG></P></BODY></HTML> Thu, 14 Dec 2017 15:44:25 GMT sunny_talwar 2017-12-14T15:44:25Z Extract set of Dates https://community.qlik.com/t5/App-Development/Extract-set-of-Dates/m-p/1406808#M32904 <HTML><HEAD></HEAD><BODY><P>Hello Guys, </P><P></P><P>I have column with dates ranging from&nbsp; <SPAN style="font-size: 13.3333px;">2015/01/01 to 2019/01/01 </SPAN>in 'YYYYMMDD' format. </P><P>I need to have a separate column with <STRONG>All dates Greater than 2016/01/01 . </STRONG></P><P></P><P>Kindly help. </P><P>Thanks,</P><P>Ravi </P></BODY></HTML> Thu, 14 Dec 2017 14:51:46 GMT https://community.qlik.com/t5/App-Development/Extract-set-of-Dates/m-p/1406808#M32904 Anonymous 2017-12-14T14:51:46Z Re: Extract set of Dates https://community.qlik.com/t5/App-Development/Extract-set-of-Dates/m-p/1406809#M32905 <HTML><HEAD></HEAD><BODY><P>May be you can just do this</P><P></P><P><STRONG>LOAD Date,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; If(Date &gt;= MakeDate(2016), Date) as NewDateColumn</STRONG></P><P><STRONG>FROM ...</STRONG></P></BODY></HTML> Thu, 14 Dec 2017 15:44:25 GMT https://community.qlik.com/t5/App-Development/Extract-set-of-Dates/m-p/1406809#M32905 sunny_talwar 2017-12-14T15:44:25Z Re: Extract set of Dates https://community.qlik.com/t5/App-Development/Extract-set-of-Dates/m-p/1406810#M32906 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny,</P><P></P><P>sorry but it does not work for me . </P><P>I want this expression in visualization:-</P><P>My column name is :- PIDates </P><P>makedate fucntion wil it be like this :- 2016/01/01</P></BODY></HTML> Thu, 14 Dec 2017 15:57:15 GMT https://community.qlik.com/t5/App-Development/Extract-set-of-Dates/m-p/1406810#M32906 Anonymous 2017-12-14T15:57:15Z Re: Extract set of Dates https://community.qlik.com/t5/App-Development/Extract-set-of-Dates/m-p/1406811#M32907 <HTML><HEAD></HEAD><BODY><P>Not sure I follow... can you provide more details? A sample may be?</P></BODY></HTML> Thu, 14 Dec 2017 16:02:34 GMT https://community.qlik.com/t5/App-Development/Extract-set-of-Dates/m-p/1406811#M32907 sunny_talwar 2017-12-14T16:02:34Z Re: Extract set of Dates https://community.qlik.com/t5/App-Development/Extract-set-of-Dates/m-p/1406812#M32908 <HTML><HEAD></HEAD><BODY><P>Ok I have attached a sample file . Kindly find the attachment .</P><P></P><P>Thanks,</P><P>ravi</P></BODY></HTML> Thu, 14 Dec 2017 16:09:07 GMT https://community.qlik.com/t5/App-Development/Extract-set-of-Dates/m-p/1406812#M32908 Anonymous 2017-12-14T16:09:07Z Re: Extract set of Dates https://community.qlik.com/t5/App-Development/Extract-set-of-Dates/m-p/1406813#M32909 <HTML><HEAD></HEAD><BODY><P>I see a bunch of dates... what do we do with them <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />... </P></BODY></HTML> Thu, 14 Dec 2017 16:10:38 GMT https://community.qlik.com/t5/App-Development/Extract-set-of-Dates/m-p/1406813#M32909 sunny_talwar 2017-12-14T16:10:38Z Re: Extract set of Dates https://community.qlik.com/t5/App-Development/Extract-set-of-Dates/m-p/1406814#M32910 <HTML><HEAD></HEAD><BODY><P>Yes I want to create another column with all dates greater than 2016/01/01. As I have to use this as a expression in a visualization. </P></BODY></HTML> Thu, 14 Dec 2017 16:12:48 GMT https://community.qlik.com/t5/App-Development/Extract-set-of-Dates/m-p/1406814#M32910 Anonymous 2017-12-14T16:12:48Z Re: Extract set of Dates https://community.qlik.com/t5/App-Development/Extract-set-of-Dates/m-p/1406815#M32911 <HTML><HEAD></HEAD><BODY><P>So this is used a dimension and you want to only see data after 2016/01/01? If this is true, check out <A href="https://community.qlik.com/qlik-blogpost/4394">Dates in Set Analysis</A></P></BODY></HTML> Thu, 14 Dec 2017 16:13:55 GMT https://community.qlik.com/t5/App-Development/Extract-set-of-Dates/m-p/1406815#M32911 sunny_talwar 2017-12-14T16:13:55Z Re: Extract set of Dates https://community.qlik.com/t5/App-Development/Extract-set-of-Dates/m-p/1406816#M32912 <HTML><HEAD></HEAD><BODY><P>Yes you are right I want to use it as Dimension. </P><P>Thanks for the link but I guess , I am not able to relate it to my scenario . </P><P>can u suggest some expression if you could ?</P><P></P><P>Thanks</P></BODY></HTML> Thu, 14 Dec 2017 16:25:22 GMT https://community.qlik.com/t5/App-Development/Extract-set-of-Dates/m-p/1406816#M32912 Anonymous 2017-12-14T16:25:22Z Re: Extract set of Dates https://community.qlik.com/t5/App-Development/Extract-set-of-Dates/m-p/1406817#M32913 <HTML><HEAD></HEAD><BODY><P>2 options</P><P></P><P>1) Use calculated dimension</P><P><STRONG>If(DateField&gt;= MakeDate(2016), DateField)</STRONG></P><P></P><P>2) Use Set Analysis</P><P><STRONG>Sum({&lt;DateField = {"$(='&gt;=' &amp; Date(MakeDate(2016), 'YourDateFieldFormatHere'))"}&gt;}Measure)</STRONG></P></BODY></HTML> Thu, 14 Dec 2017 16:29:22 GMT https://community.qlik.com/t5/App-Development/Extract-set-of-Dates/m-p/1406817#M32913 sunny_talwar 2017-12-14T16:29:22Z Re: Extract set of Dates https://community.qlik.com/t5/App-Development/Extract-set-of-Dates/m-p/1406818#M32914 <HTML><HEAD></HEAD><BODY><P>Thanks a lot sunny ! </P><P>It worked for me ! </P></BODY></HTML> Thu, 14 Dec 2017 16:56:46 GMT https://community.qlik.com/t5/App-Development/Extract-set-of-Dates/m-p/1406818#M32914 Anonymous 2017-12-14T16:56:46Z