topic YTD calculation using GetFieldSelection in QlikView

YTD calculation using GetFieldSelection

Tue, 04 Dec 2012 16:16:53 GMT

I have some reports that populate the data within them by using the Get Field Selection function. For example the user must select a month and year, and then the report will populate that dates selected units:

Sum({< detailmonth = {"$(=GetFieldSelections(detailmonth))"}, detailyear = {"$(=GetFieldSelections(detailyear))"} >} units)

This works great for getting month selected units, prior month, month over month comparision, prior year, and year over year comparison. Now I need to get the YTD based on the month selected. Meaning if they selected month 5 and year 2012 that it would sum months 1-5 for 2012, or if month 8 then sum months 1-8. Anybody have suggestions on how to do this? I'm drawing a blank based on current design.

Thanks,

Rebecca

Re: YTD calculation using GetFieldSelection

MayilVahanan — Tue, 04 Dec 2012 17:06:05 GMT

Try like this

Sum({<MonthField=,YearField=,DateField={">=$(=YearStart(Max(DateField)))<=$(=MonthEnd(Max(DateField)))"}>} FieldName)"

Hope it helps

Re: YTD calculation using GetFieldSelection

Tue, 04 Dec 2012 17:48:12 GMT

Perfect! Thank you Mayil! I was putting the <= in the wrong place. I appreciate your help!! Thanks again!