Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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';
you can simplify using flag in calendar as explained here
http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/03/ytd