topic Re: Conversion to MTD in QlikView https://community.qlik.com/t5/QlikView/Conversion-to-MTD/m-p/636687#M542254 <HTML><HEAD></HEAD><BODY><P>Please elaborate more </P><P></P><P>Or you can use a expression like</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Count( {&lt;Datefield = {'&gt;= $( =Monthstart(Datefield)&nbsp; )&nbsp; &lt;= $( =Today(DateField) ) '}&gt;} FLNO)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">What is the use of <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">not IsNull(ONBL) and Len(Trim(OFBL)) </SPAN> fields<BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P></BODY></HTML> Tue, 03 Jun 2014 07:45:38 GMT its_anandrjs 2014-06-03T07:45:38Z Conversion to MTD https://community.qlik.com/t5/QlikView/Conversion-to-MTD/m-p/636685#M542252 <HTML><HEAD></HEAD><BODY><P>How to convert the below expression to MTD</P><P></P><P> Count(if(not IsNull(ONBL) and Len(Trim(OFBL)) &lt;=0 ,FLNO))</P></BODY></HTML> Tue, 03 Jun 2014 07:29:47 GMT https://community.qlik.com/t5/QlikView/Conversion-to-MTD/m-p/636685#M542252 2014-06-03T07:29:47Z Re: Conversion to MTD https://community.qlik.com/t5/QlikView/Conversion-to-MTD/m-p/636686#M542253 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>go through the below post.</P><P><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-6163">http://community.qlik.com/docs/DOC-6163</A></P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Tue, 03 Jun 2014 07:34:06 GMT https://community.qlik.com/t5/QlikView/Conversion-to-MTD/m-p/636686#M542253 ashfaq_haseeb 2014-06-03T07:34:06Z Re: Conversion to MTD https://community.qlik.com/t5/QlikView/Conversion-to-MTD/m-p/636687#M542254 <HTML><HEAD></HEAD><BODY><P>Please elaborate more </P><P></P><P>Or you can use a expression like</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Count( {&lt;Datefield = {'&gt;= $( =Monthstart(Datefield)&nbsp; )&nbsp; &lt;= $( =Today(DateField) ) '}&gt;} FLNO)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">What is the use of <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">not IsNull(ONBL) and Len(Trim(OFBL)) </SPAN> fields<BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P></BODY></HTML> Tue, 03 Jun 2014 07:45:38 GMT https://community.qlik.com/t5/QlikView/Conversion-to-MTD/m-p/636687#M542254 its_anandrjs 2014-06-03T07:45:38Z Re: Conversion to MTD https://community.qlik.com/t5/QlikView/Conversion-to-MTD/m-p/636688#M542255 <HTML><HEAD></HEAD><BODY><P>this is the calculation condition for counting the Flight no.,now the user want to see this value on month on month&nbsp; basis</P></BODY></HTML> Tue, 03 Jun 2014 08:26:41 GMT https://community.qlik.com/t5/QlikView/Conversion-to-MTD/m-p/636688#M542255 2014-06-03T08:26:41Z