topic year month in QlikView https://community.qlik.com/t5/QlikView/year-month/m-p/343156#M493793 <HTML><HEAD></HEAD><BODY><P>hello,</P><P>m getting an issue in balance sheet</P><P>using maxyear so it is giving me the data for march of every year... means year end but returns null for current year 11-12.</P><P>want 11-12 to return data for the current month else last month</P><P>what should i use??????</P></BODY></HTML> Wed, 09 May 2012 06:52:18 GMT rajni_batra 2012-05-09T06:52:18Z year month https://community.qlik.com/t5/QlikView/year-month/m-p/343156#M493793 <HTML><HEAD></HEAD><BODY><P>hello,</P><P>m getting an issue in balance sheet</P><P>using maxyear so it is giving me the data for march of every year... means year end but returns null for current year 11-12.</P><P>want 11-12 to return data for the current month else last month</P><P>what should i use??????</P></BODY></HTML> Wed, 09 May 2012 06:52:18 GMT https://community.qlik.com/t5/QlikView/year-month/m-p/343156#M493793 rajni_batra 2012-05-09T06:52:18Z