Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
shasha3006
Contributor
Contributor

Set Analysis Less than Date

Hi Good People,

want to ask, 

I want to create a set analysis  for results dated less than 12 months from the current date

this Is my script :

registered_date={"$(=Date(addmonths(MonthStart(Max(MakeDate(Year, Month))),-12),'YYYY-MM-DD'))"}

but, this didn't working.

can anyone help?

thanks 

 

 

Labels (2)
10 Replies
shasha3006
Contributor
Contributor
Author

dear @vinieme12 ,

i have try, and result below

shasha3006_1-1679909693686.png