topic How To Show YTD Figure in QlikView https://community.qlik.com/t5/QlikView/How-To-Show-YTD-Figure/m-p/141956#M21536 <HTML><HEAD></HEAD><BODY><P>Rajtechno,</P><P></P><P>Also take a look at this thread http://community.qlik.com/forums/t/15820.aspx . It has a combination of several other methods of YTD provided by community members.</P><P>Hope this helps,</P><P></P><P>Anthony</P></BODY></HTML> Tue, 21 Apr 2009 21:24:08 GMT 2009-04-21T21:24:08Z How To Show YTD Figure https://community.qlik.com/t5/QlikView/How-To-Show-YTD-Figure/m-p/141954#M21534 <HTML><HEAD></HEAD><BODY><P>Dear All</P><P></P><P>I want help in YTD</P><P></P><P>suppose i am having data from 2008 jan onwards till date and when i select say apr 2009 my pivot table show show in ytd column data from jan 2008 till apr 2009.</P><P></P><P>I am having Pivot Table</P><P></P><P>ITEMNAME YTD Sales</P><P></P><P>How to achieve this</P></BODY></HTML> Tue, 21 Apr 2009 18:03:17 GMT https://community.qlik.com/t5/QlikView/How-To-Show-YTD-Figure/m-p/141954#M21534 2009-04-21T18:03:17Z How To Show YTD Figure https://community.qlik.com/t5/QlikView/How-To-Show-YTD-Figure/m-p/141955#M21535 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>in this case a kind of Set Analysis expression could help.</P><P>Sum({ $&lt;Year=, Month=&gt; * 1&lt; OrderDate= {"&gt;=$(=Min({1} OrderDate)) &lt;=$(=Max(OrderDate))"} &gt;} Amount)</P><P>Have a try ...</P><P>Rainer</P></BODY></HTML> Tue, 21 Apr 2009 20:55:07 GMT https://community.qlik.com/t5/QlikView/How-To-Show-YTD-Figure/m-p/141955#M21535 2009-04-21T20:55:07Z How To Show YTD Figure https://community.qlik.com/t5/QlikView/How-To-Show-YTD-Figure/m-p/141956#M21536 <HTML><HEAD></HEAD><BODY><P>Rajtechno,</P><P></P><P>Also take a look at this thread http://community.qlik.com/forums/t/15820.aspx . It has a combination of several other methods of YTD provided by community members.</P><P>Hope this helps,</P><P></P><P>Anthony</P></BODY></HTML> Tue, 21 Apr 2009 21:24:08 GMT https://community.qlik.com/t5/QlikView/How-To-Show-YTD-Figure/m-p/141956#M21536 2009-04-21T21:24:08Z