topic Re: How to get YTD values using MTD field in qlikview? in QlikView https://community.qlik.com/t5/QlikView/How-to-get-YTD-values-using-MTD-field-in-qlikview/m-p/1250045#M395748 <HTML><HEAD></HEAD><BODY><P>It would be better if you have provided sample data to work or sample application.</P><P>If possible, also provide your required output.</P></BODY></HTML> Thu, 29 Dec 2016 15:36:44 GMT MK_QSL 2016-12-29T15:36:44Z How to get YTD values using MTD field in qlikview? https://community.qlik.com/t5/QlikView/How-to-get-YTD-values-using-MTD-field-in-qlikview/m-p/1250044#M395747 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>we have Amount_MTD and <SPAN style="font-size: 10pt;">Amount_ITD field are available in database but not available Amount_YTD. As per requirement we need to display MTD,YTD,ITD views in bar </SPAN><SPAN style="font-size: 10pt;">chats and we able to show MTD and ITD view but not YTD due to not available in the database.</SPAN></P><P></P><P>top of dashboard we have created Year and Month filters and according to these filters we need to show YTD values in the dashboard.</P><P></P><P>So please suggest that how to create YTD expression using MTD amount.</P><P>Note:&nbsp; there is no amount field available in the database to create YTD. Only amount_MTD and amount_ITD field available in the database.</P><P></P><P>thanks........................</P></BODY></HTML> Thu, 29 Dec 2016 14:16:56 GMT https://community.qlik.com/t5/QlikView/How-to-get-YTD-values-using-MTD-field-in-qlikview/m-p/1250044#M395747 srinivas1921 2016-12-29T14:16:56Z Re: How to get YTD values using MTD field in qlikview? https://community.qlik.com/t5/QlikView/How-to-get-YTD-values-using-MTD-field-in-qlikview/m-p/1250045#M395748 <HTML><HEAD></HEAD><BODY><P>It would be better if you have provided sample data to work or sample application.</P><P>If possible, also provide your required output.</P></BODY></HTML> Thu, 29 Dec 2016 15:36:44 GMT https://community.qlik.com/t5/QlikView/How-to-get-YTD-values-using-MTD-field-in-qlikview/m-p/1250045#M395748 MK_QSL 2016-12-29T15:36:44Z Re: How to get YTD values using MTD field in qlikview? https://community.qlik.com/t5/QlikView/How-to-get-YTD-values-using-MTD-field-in-qlikview/m-p/1250046#M395749 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>please read this:</P><P></P><P><A href="https://community.qlik.com/docs/DOC-4252">Calculating rolling n-period totals, averages or other aggregations</A></P><P></P><P>I hope you have at least a field that indicates which month it referes to...</P><P></P><P>HTH</P><P></P><P>André Gomes</P></BODY></HTML> Thu, 29 Dec 2016 16:00:18 GMT https://community.qlik.com/t5/QlikView/How-to-get-YTD-values-using-MTD-field-in-qlikview/m-p/1250046#M395749 agomes1971 2016-12-29T16:00:18Z