topic Re: YTD with multple Dimesions in QlikView https://community.qlik.com/t5/QlikView/YTD-with-multple-Dimesions/m-p/140762#M20947 <HTML><HEAD></HEAD><BODY><P>If 9 here indicating month number one less than today's month, you could define a variable and use it in the expression like:</P><P><EM>vPreMonth=Num(Month(Today()))-1</EM></P><P><EM><BR /></EM></P><P>Then replace your hard coded number with <EM>$(vPreMonth)</EM></P></BODY></HTML> Mon, 29 Oct 2018 08:25:55 GMT tresB 2018-10-29T08:25:55Z YTD with multple Dimesions https://community.qlik.com/t5/QlikView/YTD-with-multple-Dimesions/m-p/140761#M20946 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am calculating YTD with two dimension. I am using RangeSum and Above function. I am struggling in Above function. Kindly help me.</P><P></P><P>Expression:</P><P></P><P>RangeSum(Above(sum({&lt;IMSMonthName,IMSYear,DATAPERIOD={"&gt;=$(=date(AddYears(YearStart(date#(max(DATAPERIOD),'YYYYMM')),-1),'YYYYMM'))&lt;=$(=date(addyears(date#(max(DATAPERIOD),'YYYYMM'),-1),'YYYYMM'))"}&gt;}NVALUE)/1000000,<STRONG style=": ; color: #ff0000;">9</STRONG>,RowNo()))</P><P></P><P>I have hot coded <STRONG style="color: #ff0000;">9</STRONG>. How to achieve this instead of hot coded by month.</P><P></P><P>Regards,</P><P>Dinesh Kumar Mani.</P></BODY></HTML> Mon, 29 Oct 2018 05:53:50 GMT https://community.qlik.com/t5/QlikView/YTD-with-multple-Dimesions/m-p/140761#M20946 dineshm030 2018-10-29T05:53:50Z Re: YTD with multple Dimesions https://community.qlik.com/t5/QlikView/YTD-with-multple-Dimesions/m-p/140762#M20947 <HTML><HEAD></HEAD><BODY><P>If 9 here indicating month number one less than today's month, you could define a variable and use it in the expression like:</P><P><EM>vPreMonth=Num(Month(Today()))-1</EM></P><P><EM><BR /></EM></P><P>Then replace your hard coded number with <EM>$(vPreMonth)</EM></P></BODY></HTML> Mon, 29 Oct 2018 08:25:55 GMT https://community.qlik.com/t5/QlikView/YTD-with-multple-Dimesions/m-p/140762#M20947 tresB 2018-10-29T08:25:55Z