topic Re: QTD & YTD in QlikView https://community.qlik.com/t5/QlikView/QTD-YTD/m-p/574687#M1117153 <HTML><HEAD></HEAD><BODY><P>Please share your excel or sample qvw to help you.</P><P></P><P>Vikas <IMG src="https://community.qlik.com/legacyfs/online/emoticons/cool.png" /></P></BODY></HTML> Wed, 12 Feb 2014 11:06:02 GMT vikasmahajan 2014-02-12T11:06:02Z QTD & YTD https://community.qlik.com/t5/QlikView/QTD-YTD/m-p/574684#M1117150 <HTML><HEAD></HEAD><BODY><P>How to create QTD n YTD chart?</P></BODY></HTML> Wed, 12 Feb 2014 10:34:43 GMT https://community.qlik.com/t5/QlikView/QTD-YTD/m-p/574684#M1117150 renuka_sasikumar 2014-02-12T10:34:43Z Re: QTD & YTD https://community.qlik.com/t5/QlikView/QTD-YTD/m-p/574685#M1117151 <HTML><HEAD></HEAD><BODY><P>PFA sample Application hope this help you.</P><P></P><P>Vikas</P></BODY></HTML> Wed, 12 Feb 2014 10:38:28 GMT https://community.qlik.com/t5/QlikView/QTD-YTD/m-p/574685#M1117151 vikasmahajan 2014-02-12T10:38:28Z Re: QTD & YTD https://community.qlik.com/t5/QlikView/QTD-YTD/m-p/574686#M1117152 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I didn't get it how to do it in QV</P><P></P><P>M new to dis</P></BODY></HTML> Wed, 12 Feb 2014 10:57:39 GMT https://community.qlik.com/t5/QlikView/QTD-YTD/m-p/574686#M1117152 renuka_sasikumar 2014-02-12T10:57:39Z Re: QTD & YTD https://community.qlik.com/t5/QlikView/QTD-YTD/m-p/574687#M1117153 <HTML><HEAD></HEAD><BODY><P>Please share your excel or sample qvw to help you.</P><P></P><P>Vikas <IMG src="https://community.qlik.com/legacyfs/online/emoticons/cool.png" /></P></BODY></HTML> Wed, 12 Feb 2014 11:06:02 GMT https://community.qlik.com/t5/QlikView/QTD-YTD/m-p/574687#M1117153 vikasmahajan 2014-02-12T11:06:02Z Re: Re: QTD & YTD https://community.qlik.com/t5/QlikView/QTD-YTD/m-p/574688#M1117154 <HTML><HEAD></HEAD><BODY><P>I have attached the qvw</P><P></P><P>Required QTD &amp; YTD</P></BODY></HTML> Wed, 12 Feb 2014 11:10:44 GMT https://community.qlik.com/t5/QlikView/QTD-YTD/m-p/574688#M1117154 renuka_sasikumar 2014-02-12T11:10:44Z Re: QTD & YTD https://community.qlik.com/t5/QlikView/QTD-YTD/m-p/574689#M1117155 <HTML><HEAD></HEAD><BODY><P>Dear Renuka,</P><P>Your data only showing for Year 2012 which is not helping us to create YTD, MTD or QTD.</P><P>Considering that you want your calculation for Current Year, use below formula.</P><P></P><P>FOR YTD</P><P>=SUM({&lt;Date = {'&lt;=$(=Date(Today()))'}, Year = {'$(=Year(Today()))'}&gt;}[TOTAL INVOICE VALUE])</P></BODY></HTML> Wed, 12 Feb 2014 11:29:37 GMT https://community.qlik.com/t5/QlikView/QTD-YTD/m-p/574689#M1117155 MK_QSL 2014-02-12T11:29:37Z