topic Year To Date Enquiry in QlikView

Year To Date Enquiry

Mon, 03 Sep 2012 11:19:44 GMT

Year	Month	Amount
2011	May	2
2011	Jun	3
2011	Jul	4
2011	Aug	6
2011	Sep	3
2011	Oct	8
2011	Nov	2
2011	Dec	2
2012	Jan	8
2012	Feb	4
2012	Mar	6
2012	Apl	4
2012	May	2
2012	Jun	6

I have data like this and i have no problem that allow user to filter it by clicking the year and month.

But when i would like to do the year-to-date, i have difficulty for such date range YTD Jun 2012 = 1 July 2012 - 30 June 2012 to be dynamic with this similar formula :

sum({1}if(Month<= $(Month)

I appreciate that anyone can help me and share with me any idea to work it out as such case...

billion thanks.

Re: Year To Date Enquiry

whiteline — Mon, 03 Sep 2012 11:32:27 GMT

There is a function YearToDate.

Re: Year To Date Enquiry

senpradip007 — Mon, 03 Sep 2012 12:12:37 GMT

Hi jeffrey_0202

You can use the following formula

Sum({$<Year={$(=Max(Year))},Month={$(=Max(Month))}>} Amount)

Hope it will help you.

Regards

Pradip

Re: Year To Date Enquiry

Mon, 10 Sep 2012 08:11:56 GMT

Hi,

just try to apply your script, it seen doesn't work as it always return me 0 and i have try to replace the max year and max month as follow eg.:

Sum({$<Year={$(='2012')},Month={$(='Jun')}>} Amount)

the result i always get is 2012 Jun data only and is 6.

Enclose to you also for the Script :

LOAD * INLINE [

Year11, Month11, Amount11

2011, May, 2

2011, Jun, 3

2011, Jul, 4

2011, Aug, 6

2011, Sep, 3

2011, Oct, 8

2011, Nov, 2

2011, Dec, 2

2012, Jan, 8

2012, Feb, 4

2012, Mar, 6

2012, Apl, 4

2012, May, 2

2012, Jun, 6

];

Appreciate tah you can provide me some advice on this aspecially for dynamic selection : click 2012(year). May(month) it's will should me result from 201107 - 201205. and so on..

Thanks.