Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

YTD Calculation

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

4 Replies
AbhijitBansode
Specialist
Specialist

it will give you YTD of (Billing_Sales_Value-Booking_Sales_Value)

tresesco
MVP
MVP

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

Not applicable
Author

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
Not applicable
Author

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