How To Show YTD Figure

[#1]

Dear All

I want help in YTD

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.

I am having Pivot Table

ITEMNAME YTD Sales

How to achieve this

[#2]

Hello,

in this case a kind of Set Analysis expression could help.

Sum({ $<Year=, Month=> * 1< OrderDate= {">=$(=Min({1} OrderDate)) <=$(=Max(OrderDate))"} >} Amount)

Have a try ...

Rainer

[#3 · Accepted solution]

Rajtechno,

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.

Hope this helps,

Anthony