topic YTD MTD in QlikView https://community.qlik.com/t5/QlikView/YTD-MTD/m-p/800574#M282560 <HTML><HEAD></HEAD><BODY><P>Hi to all,</P><P></P><P>=num((sum({&lt;BILLDETAILENTRYTYPE = {'B'}, BILLCANCELLED = {'N'}, BILLESTIMATE = {'N'}&gt;}BILLDETAILGROSSWEIGHT)/WeightFlag)<BR />-<BR />(sum({&lt;BILLDETAILENTRYTYPE = {'R'}, BILLCANCELLED = {'N'}, BILLESTIMATE = {'N'}&gt;}BILLDETAILGROSSWEIGHT)/WeightFlag)<BR />-<BR />(sum({&lt;BILLDETAILENTRYTYPE = {'O'}, BILLCANCELLED = {'N'}, BILLESTIMATE = {'N'}, URDPURCHASE = {'Y'}&gt;}BILLDETAILGROSSWEIGHT)/WeightFlag),'##.00')</P><P></P><P></P><P>Label name:Gross Weight</P><P></P><P></P><P>I have this expression, I want Calculate YTD,MTD&amp;WTD, how can i do that please help me </P><P></P><P></P><P>Thanks in Advance.</P><P>chandra </P></BODY></HTML> Fri, 13 Feb 2015 09:27:35 GMT 2015-02-13T09:27:35Z YTD MTD https://community.qlik.com/t5/QlikView/YTD-MTD/m-p/800574#M282560 <HTML><HEAD></HEAD><BODY><P>Hi to all,</P><P></P><P>=num((sum({&lt;BILLDETAILENTRYTYPE = {'B'}, BILLCANCELLED = {'N'}, BILLESTIMATE = {'N'}&gt;}BILLDETAILGROSSWEIGHT)/WeightFlag)<BR />-<BR />(sum({&lt;BILLDETAILENTRYTYPE = {'R'}, BILLCANCELLED = {'N'}, BILLESTIMATE = {'N'}&gt;}BILLDETAILGROSSWEIGHT)/WeightFlag)<BR />-<BR />(sum({&lt;BILLDETAILENTRYTYPE = {'O'}, BILLCANCELLED = {'N'}, BILLESTIMATE = {'N'}, URDPURCHASE = {'Y'}&gt;}BILLDETAILGROSSWEIGHT)/WeightFlag),'##.00')</P><P></P><P></P><P>Label name:Gross Weight</P><P></P><P></P><P>I have this expression, I want Calculate YTD,MTD&amp;WTD, how can i do that please help me </P><P></P><P></P><P>Thanks in Advance.</P><P>chandra </P></BODY></HTML> Fri, 13 Feb 2015 09:27:35 GMT https://community.qlik.com/t5/QlikView/YTD-MTD/m-p/800574#M282560 2015-02-13T09:27:35Z Re: YTD MTD https://community.qlik.com/t5/QlikView/YTD-MTD/m-p/800575#M282561 <HTML><HEAD></HEAD><BODY><P>pls check the below link</P><P></P><P><A href="https://community.qlik.com/docs/DOC-6163">YTQ, QTD, MTD and WTD</A></P></BODY></HTML> Fri, 13 Feb 2015 09:29:47 GMT https://community.qlik.com/t5/QlikView/YTD-MTD/m-p/800575#M282561 manojkulkarni 2015-02-13T09:29:47Z Re: YTD MTD https://community.qlik.com/t5/QlikView/YTD-MTD/m-p/800576#M282562 <HTML><HEAD></HEAD><BODY><P>Hi Manoj,</P><P></P><P>where Can i write please give me Navigation</P><P></P><P>Thanks for your reply</P></BODY></HTML> Fri, 13 Feb 2015 09:37:35 GMT https://community.qlik.com/t5/QlikView/YTD-MTD/m-p/800576#M282562 2015-02-13T09:37:35Z