topic Re: YTD & MTD in QlikView https://community.qlik.com/t5/QlikView/YTD-MTD/m-p/1117889#M888157 <HTML><HEAD></HEAD><BODY><P>Have you tried anything. If yes, please post those Two set operator's</P></BODY></HTML> Wed, 31 Aug 2016 06:30:58 GMT Anil_Babu_Samineni 2016-08-31T06:30:58Z YTD & MTD https://community.qlik.com/t5/QlikView/YTD-MTD/m-p/1117888#M888156 <HTML><HEAD></HEAD><BODY><P>HI,</P><P>In my table i am having date,fiscal month,fiscal year field for this i want to write YTD &amp; MTD . How to do it??</P><P></P><P></P><P>Thanks!!!!!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/YTD-MTD/m-p/1117888#M888156 lionking15 2020-11-25T16:16:04Z Re: YTD & MTD https://community.qlik.com/t5/QlikView/YTD-MTD/m-p/1117889#M888157 <HTML><HEAD></HEAD><BODY><P>Have you tried anything. If yes, please post those Two set operator's</P></BODY></HTML> Wed, 31 Aug 2016 06:30:58 GMT https://community.qlik.com/t5/QlikView/YTD-MTD/m-p/1117889#M888157 Anil_Babu_Samineni 2016-08-31T06:30:58Z Re: YTD & MTD https://community.qlik.com/t5/QlikView/YTD-MTD/m-p/1117890#M888158 <HTML><HEAD></HEAD><BODY><P>This may helps you</P><P></P><P><A href="https://community.qlik.com/docs/DOC-6163">YTQ, QTD, MTD and WTD</A></P></BODY></HTML> Wed, 31 Aug 2016 06:34:01 GMT https://community.qlik.com/t5/QlikView/YTD-MTD/m-p/1117890#M888158 2016-08-31T06:34:01Z Re: YTD & MTD https://community.qlik.com/t5/QlikView/YTD-MTD/m-p/1117891#M888159 <HTML><HEAD></HEAD><BODY><P>follow this</P><P><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-6163" title="https://community.qlik.com/docs/DOC-6163">https://community.qlik.com/docs/DOC-6163</A></P></BODY></HTML> Wed, 31 Aug 2016 06:34:06 GMT https://community.qlik.com/t5/QlikView/YTD-MTD/m-p/1117891#M888159 arulsettu 2016-08-31T06:34:06Z Re: YTD & MTD https://community.qlik.com/t5/QlikView/YTD-MTD/m-p/1117892#M888160 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Hope this qvw will help you.</P></BODY></HTML> Wed, 31 Aug 2016 06:35:16 GMT https://community.qlik.com/t5/QlikView/YTD-MTD/m-p/1117892#M888160 bindu_apte 2016-08-31T06:35:16Z Re: YTD & MTD https://community.qlik.com/t5/QlikView/YTD-MTD/m-p/1117893#M888161 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Suppose i select '21/02/2016' then YTD should show year between '01/04/2015' to 21/02/2016 as per fiscal year </P></BODY></HTML> Wed, 31 Aug 2016 06:45:43 GMT https://community.qlik.com/t5/QlikView/YTD-MTD/m-p/1117893#M888161 lionking15 2016-08-31T06:45:43Z Re: YTD & MTD https://community.qlik.com/t5/QlikView/YTD-MTD/m-p/1117894#M888162 <HTML><HEAD></HEAD><BODY><P>can you post your qvw</P></BODY></HTML> Wed, 31 Aug 2016 07:09:17 GMT https://community.qlik.com/t5/QlikView/YTD-MTD/m-p/1117894#M888162 arulsettu 2016-08-31T07:09:17Z Re: YTD & MTD https://community.qlik.com/t5/QlikView/YTD-MTD/m-p/1117895#M888163 <HTML><HEAD></HEAD><BODY><P>For YTD i have written </P><P>=sum({&lt;Date={'&gt;$(=monthstart(min(Date)) )&lt;=$(=max(Date))'}&gt;}[Sales Amount]) is it correct???</P></BODY></HTML> Wed, 31 Aug 2016 07:35:54 GMT https://community.qlik.com/t5/QlikView/YTD-MTD/m-p/1117895#M888163 lionking15 2016-08-31T07:35:54Z