topic YTD Calculation in QlikView

YTD Calculation

Thu, 19 Feb 2015 12:44:19 GMT

HI Guys

Iam using the below formula to calculate sum of YTD, and it is working fine

=Sum({$<FiscalYear={$(=Max(FiscalYear))},[FiscalMonth]={"<=$(=max([FiscalMonth])-1)"},FiscalMonthName=>}(Billing_Sales_Value-Booking_Sales_Value))

I just want to know is it giving me the ytd of both Billing _Sales_Value - YTD of Booking_Sales_Value .

Or just it is giving me the YTD of Billing _Sales_Value

Thanks in advance

AbhijitBansode — Thu, 19 Feb 2015 12:48:53 GMT

it will give you YTD of (Billing_Sales_Value-Booking_Sales_Value)

tresB — Thu, 19 Feb 2015 12:49:32 GMT

It follows simple mathematics and hence, you get 'ytd of (Billing _Sales_Value - YTD of Booking_Sales_Value )'

Thu, 19 Feb 2015 12:51:57 GMT

Thanks for the reply

It means it will give the YTD for Booking_Sales_Value and as well as YTD Billing Sales _Value right ?

Anonymous — Thu, 19 Feb 2015 12:52:29 GMT

Hi,

it will give you year to previous month of (Billing_Sales_Value-Booking_Sales_Value)

not YTD

(=max([FiscalMonth])-1) - this query selects data for previous month

for YTD give(=max([FiscalMonth])) remove -1