problem with inyeartodate function.

[#1]

hi, well i'm new in qlikview, and i have a problem with the function inyeartodate, i need to obtain the sum of a range o dates, this part works well, in my qvw i have a selection of year and month  and a  table where i show this data, if i don't select a year, the function does what supose to do, but when i select a year, the column with de expresion of this function put all the values in 0, i don't know if i'm clear with my problem, but i hope that some one can help me.

pd. sorry for my english

[gussfish]

What are the dimensions of your table and what is the expression you're

using the function in? And how is your data structured?

[#3]

this is my expresion.

Sum(InYearToDate(InvoiceDate,SetDateYear(varMaxDate,$(=max(Year))),-1)*-1 * Amount)

varMaxDate is my top date so with setdateyear i try to chage de year of this date when i select a year but it doesn't work, my dimension is a group, includes client, county, salesperson, the table of sales invoice contains the primary key of the client and salesperson and this are related with the table clients and salespersons, the table of sales invoice is related with a master calendar where i have de dates that i select.

well this i think this is all.

[#4]

use this in your load statement:if (year2date(Date),1,nul()) as YTD and then in your expression YTD * Amount

at least if I understand your problem....