YTD Expression Issue

Thu, 03 Jan 2013 10:49:25 GMT

Hi,

I want to create an expression which will calculate the sum of my dimension from april month of a year to current date.

Thanks,

Utsav

Re: YTD Expression Issue

nirav_bhimani — Thu, 03 Jan 2013 11:01:06 GMT

Hi,

you are using financial year or normal year?

this work with Fin Year as you want.

In Script // QuarterStart(CalendarDate) as QuaterStartDate,

In Variable //vMaxDate= Max(CalendarDate) OR vMaxDate= (Today())

(sum(
{<
CalendarDate = {">=$(= Date (min({<CalendarWeekOfYear=, FinancialQuarter=, MonthName=>} QuaterStartDate )))<=$(vMaxDate))" }
, CalendarWeekOfYear=, FinancialQuarter=, MonthName=
>}
Sales))

Hope this will help you.

Regards,

Nirav Bhimani.

topic Re: YTD Expression Issue in QlikView

YTD Expression Issue

Re: YTD Expression Issue