topic Income MTD in QlikView https://community.qlik.com/t5/QlikView/Income-MTD/m-p/207367#M63150 <HTML><HEAD></HEAD><BODY><P>HI All</P><P>Im stuck again, im doing a project and i need to work out the MTD income and compair it with the prev MTD income.I just cant get it ryt!!!! If any one have any expressios that can work???</P><P>Regards</P><P>Thanx to all that can help....</P></BODY></HTML> Wed, 09 Feb 2011 10:37:25 GMT stevietm 2011-02-09T10:37:25Z Income MTD https://community.qlik.com/t5/QlikView/Income-MTD/m-p/207367#M63150 <HTML><HEAD></HEAD><BODY><P>HI All</P><P>Im stuck again, im doing a project and i need to work out the MTD income and compair it with the prev MTD income.I just cant get it ryt!!!! If any one have any expressios that can work???</P><P>Regards</P><P>Thanx to all that can help....</P></BODY></HTML> Wed, 09 Feb 2011 10:37:25 GMT https://community.qlik.com/t5/QlikView/Income-MTD/m-p/207367#M63150 stevietm 2011-02-09T10:37:25Z Income MTD https://community.qlik.com/t5/QlikView/Income-MTD/m-p/207368#M63151 <HTML><HEAD></HEAD><BODY><P style="font-style: italic"></P><P></P><P></P><P></P><I></I> <P></P><I></I><I></I> <P><B>//Current month-to-date</B></P><P></P><P>inmonthtodate</P><BR /><BR /> <BR /><BR /> <P></P><P></P><BR /><BR /> <P></P><P></P><BR /><BR /> <P>(D, <B><I>$(vToday)</I></B>, 0) * -1 <B>AS</B> CMTD,</P><BR /><BR /> <P><B>//Previous month-to-date</B></P><P></P><P></P><P></P><BR /><BR /> <P></P><P></P><BR /><BR /> <BR /><BR /> <P></P><P></P><P>inmonthtodate(D, <B><I>$(vToday)</I></B>, -1) * -1 <B>AS</B> PMTD,</P><P style="font-weight: bold"></P><BR /><BR /> <P></P><BR /><BR /></BODY></HTML> Wed, 09 Feb 2011 11:10:19 GMT https://community.qlik.com/t5/QlikView/Income-MTD/m-p/207368#M63151 suniljain 2011-02-09T11:10:19Z