topic Re: LYTD in QlikView

LYTD

NavinReddy — Thu, 13 Mar 2014 17:58:40 GMT

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

Re: LYTD

Gysbert_Wassenaar — Thu, 13 Mar 2014 18:01:35 GMT

See this blog post: Year-over-Year Comparisons

Re: LYTD

Thu, 13 Mar 2014 18:03:52 GMT

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

Re: LYTD

NavinReddy — Thu, 13 Mar 2014 18:05:02 GMT

Hi Gysbert,

please give me one word answer simple way

What is LYTD

Regards,

Niranjan

Re: LYTD

Thu, 13 Mar 2014 18:23:21 GMT

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.