Discussion board where members can get started with QlikView.
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 :
I appreciate that anyone can help me and share with me any idea to work it out as such case...
There is a function YearToDate.
You can use the following formula
Hope it will help you.
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.:
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..