Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
NavinReddy
Creator II
Creator II

LYTD

Dear All,

LYTD-mean last year to till date (or)

last year same months comparision with this year months

plase reply some one

Thanks In Advance

Niranjan

4 Replies
Gysbert_Wassenaar

See this blog post: Year-over-Year Comparisons


talk is cheap, supply exceeds demand
Not applicable

You will need to use SET ANALYSIS (lots of help documentation on that) it allows you to specifiy different valutes than what the user has selected.

Imagine if your application has a field called START_Y that the user clicks and it they click 2013. This set analysis expression would change the formula to use the previous year, 2012 instead of 2013.

=SUM({$<START_Y={$(=Only(START_Y)-1)}>FieldYouWantSummedUp)

You need to use your own FIELD names for Year and for whatever figure you are tryingt to sum up

NavinReddy
Creator II
Creator II
Author

Hi Gysbert,

please give me one word answer simple way

What is LYTD

Regards,

Niranjan

Not applicable

Yes LYTD means Last Year To Date.

So if the user clicked and chose February 2014 and you showed those numbers. LYTD would mean you should show them the sum of the data for 2013 up to and including February. Typically it is only regarding months but you could do the same to an actual date like today.