topic LYTD in QlikView

LYTD

janardhan — Fri, 05 Sep 2014 10:18:48 GMT

Hello Friends,

Is this query is correct for lytd

Sum({<TP_Date= {">=$(=Date(YearStart(Max(TP_Date),-1)),'DD-MM-YYYY')<=$(=Date(addyears(Max(TP_Date),-1)),'DD-MM-YYYY')"}>}TP_NetPremium_LC_1)

Pls Help me

MK_QSL — Fri, 05 Sep 2014 10:27:04 GMT

LYTD.... corresponds to TODAY()

=SUM({<TP_Date= {'<=$(=AddYears(Today(),-1))>=$(=YearStart(AddYears(Today(),-1)))'}>}TP_NetPremium_LC_1)

LYTD.... corresponds to USER SELECTED TP_Date

=SUM({<TP_Date= {'<=$(=AddYears(Max(TD_Date),-1))>=$(=YearStart(AddYears(Max(TD_Date),-1)))'}>}TP_NetPremium_LC_1)

If this is not working, let me know what is the format of TD_Date and your QlikView one...

SET DateFormat='DD/MM/YYYY';

maxgro — Fri, 05 Sep 2014 10:58:21 GMT

you can simplify using flag in calendar as explained here