Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

arulsettu
Honored Contributor III

LYTD is not ging correct result

     hi

i used this script for lytd

POL_APPROVAL_Date={">=$(=YearStart(max(date(POL_APPROVAL_Date)),-1))<=$(=num(addYears(Date(Today()-1),-1)))"}

POL_APPROVAL_Date = date(floor(tp_ap_date)



can any one suggest some idea

Tags (4)
4 Replies
satishkurra
Valued Contributor II

Re: LYTD is not ging correct result

Try this. Assuming Sales is the measure and Use Date as POL_Approval_Date

=Sum({$<Date={">=$(=Num(YearStart(Max(Date),-1)))<=$(=AddYears(Max(Date),-1))"}>}Sales)

arulsettu
Honored Contributor III

Re: LYTD is not ging correct result

Sunny T here is the sample app pls take alook

MVP
MVP

Re: LYTD is not ging correct result

No data to sum here

Capture.PNG

arulsettu
Honored Contributor III

Re: LYTD is not ging correct result

will check thanks for your time sunny