topic Re: expression for date difference in selected date DB date and display in a particular column in QlikView https://community.qlik.com/t5/QlikView/expression-for-date-difference-in-selected-date-DB-date-and/m-p/477049#M178193 <HTML><HEAD></HEAD><BODY><P>Please upload a sample document. Will make our understanding of how to write the expression a lot easier.</P><P></P><P>Right now there are many ways to do this</P><P></P><P>Script - IntervalMatch()</P><P>Front - Class(), Set Analysis ({&lt;Date={'&lt;=$(=BatchDate)'}&gt;}) et cetera</P><P></P><P>Cheers,</P><P>Byron</P></BODY></HTML> Wed, 25 Sep 2013 11:22:19 GMT 2013-09-25T11:22:19Z expression for date difference in selected date DB date and display in a particular column https://community.qlik.com/t5/QlikView/expression-for-date-difference-in-selected-date-DB-date-and/m-p/477048#M178192 <HTML><HEAD></HEAD><BODY><P>HI,</P><P></P><P>I have columns for a range like 0-30,31-60,61-90 like this and depending upon date difference that is difference between <SPAN style="font-size: 10pt; line-height: 1.5em;">selected date and batch date </SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;">i want to show qty int that columns.</SPAN></P><P>how to write expression for that.</P><P><A href="https://community.qlik.com/qlik-users/2001">QlikTech Admin</A></P></BODY></HTML> Wed, 25 Sep 2013 11:08:14 GMT https://community.qlik.com/t5/QlikView/expression-for-date-difference-in-selected-date-DB-date-and/m-p/477048#M178192 2013-09-25T11:08:14Z Re: expression for date difference in selected date DB date and display in a particular column https://community.qlik.com/t5/QlikView/expression-for-date-difference-in-selected-date-DB-date-and/m-p/477049#M178193 <HTML><HEAD></HEAD><BODY><P>Please upload a sample document. Will make our understanding of how to write the expression a lot easier.</P><P></P><P>Right now there are many ways to do this</P><P></P><P>Script - IntervalMatch()</P><P>Front - Class(), Set Analysis ({&lt;Date={'&lt;=$(=BatchDate)'}&gt;}) et cetera</P><P></P><P>Cheers,</P><P>Byron</P></BODY></HTML> Wed, 25 Sep 2013 11:22:19 GMT https://community.qlik.com/t5/QlikView/expression-for-date-difference-in-selected-date-DB-date-and/m-p/477049#M178193 2013-09-25T11:22:19Z Re: expression for date difference in selected date DB date and display in a particular column https://community.qlik.com/t5/QlikView/expression-for-date-difference-in-selected-date-DB-date-and/m-p/477050#M178194 <HTML><HEAD></HEAD><BODY><P>Can you upload a sample app with small data?</P></BODY></HTML> Wed, 25 Sep 2013 11:33:45 GMT https://community.qlik.com/t5/QlikView/expression-for-date-difference-in-selected-date-DB-date-and/m-p/477050#M178194 2013-09-25T11:33:45Z